SyntaxFix

[sql-server-2005] How to install SQL Server 2005 Express in Windows 8

I had the same problem. But I also had to perform additional steps. Here is what I did.

Perform the following steps (Only 64bit version of SQL Server 2005 Developer Edition tested on Windows 8 Pro 64bit)

  1. Extract sqlncli.msi / sqlncli_x64.msi from SP3 or SP4. I did it from SP4
  2. Install sqlncli
  3. Start SQL Server 2005 Setup
  4. During setup I received an error The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
  5. Don't click cancel yet. From an installation of SQL Server 2005 SP3 or SP4 copy SQLSERVR.EXE and SQLOS.DLL files and put them in your SQL install folder.
  6. Click RETRY

For STEP 5 above: Although I didn't try looking into SP4 / SP3 setup for SQLSERVR.EXE and SQLOS.DLL but if you don't have an existing installation of SQL Server 2005 SP3/SP4 then maybe try looking into the SP3/SP4 EXE (Compressed file). I am not sure if this may help. In any case you can create a VM and install SQL Server 2005 with SP3/Sp4 to copy the files for Windows 8

Examples related to sql-server-2005

• Add a row number to result set of a SQL query • SQL Server : Transpose rows to columns • Select info from table where row has max date • How to query for Xml values and attributes from table in SQL Server? • How to restore SQL Server 2014 backup in SQL Server 2008 • SQL Server 2005 Using CHARINDEX() To split a string • Is it necessary to use # for creating temp tables in SQL server? • SQL Query to find the last day of the month • JDBC connection to MSSQL server in windows authentication mode • How to convert the system date format to dd/mm/yy in SQL Server 2008 R2?

Examples related to sql-server-2005-express

• How to install SQL Server 2005 Express in Windows 8 • Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) • Delete rows from multiple tables using a single query (SQL Express 2005) with a WHERE condition • How can I join on a stored procedure? • How to change identity column values programmatically?