How To Successfully Install SQL Server 2005 In Windows 8 – SEE DESCRIPTION PLEASE

NOTE: As specified below and at around 3:17 on the video, you need to get the two files that you need from another good installation of SQL 2005.

I get a lot of questions about how to get the two files you need. The best way to do this is to create a Virtual Machine using HyperV in Windows 8, or VMWare WorkStation, install a trial copy of Windows 7, install a trial copy of SQL 2005 and upgrade it with all the latest Service Packs. Then go get those files and copy them from the VM to your local hard drive, or upload them to Google Drive, OneDrive, or Dropbox from the VM. That’s how I would do it if I didn’t have a Windows 7 machine to install SQL 2005 on.

ALSO NOTE: SQL 2005 and SQL Express 2005 are TWO DIFFERENT PRODUCTS. You will need to get replacement files from another installation of SQL Express 2005 and download the Service Pack 4 installer for SQL Express from here:
http://catalog.update.microsoft.com/v7/site/search.aspx?q=kb2463332
(You MUST use Internet Explorer to use the Microsoft Update catalog)

SQL Server 2005 Service Pack 4 Installer can be found here:
http://catalog.update.microsoft.com/v7/site/search.aspx?q=kb2463332
(You MUST use Internet Explorer to use the Microsoft Update catalog)

This video will show you how to install SQL Server 2005 in a Windows 8 machine or any machine where you need to overcome the 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.”

Prerequisites are that you need to have the sqlserver exe and sqlos dll files from another installation that has already been upgraded to Service Pack 2, Service Pack 3, or Service Pack 4. You will also need to immediately apply a Service Pack installer for Service Pack 2 or later. I recommend Service Pack 4 because it is the latest service pack. Search Google for “How to obtain the latest service pack for SQL 2005”.