How to install and run SQL Server 2005 under Win8.1 system

As a normal situation, installing Microsoft SQL Server 2005 Suite under Win8/Win8.1 system will have compatibility problems. Even after installation, the final result is that its service items cannot be started normally.
If the user creates a project that is to be run and debugged according to the SQL Server 2005 standard, how can I use the SQL Server 2005 suite under Microsoft's latest Windows 8/Windows 8.1? Use the file replacement method to solve the temporary solution that its service items cannot be started normally. Of course, it is recommended to use SQL Server 2008 or above database. After all, the SQL Server 2012 version has been released for more than a year.
Specific steps: Take the example of installing a 64-bit database development kit.
1, run the installation program, if compatibility problems arise on the choice of & ldquo; run the program without getting help & rdquo;

2, choose the 64-bit installation


3, Select the service components you need to install

4, select the built-in system account

5, select the mixed mode login, and enter the password to log in to the database

6, when Sql Server appears When 2005 can't start, don't click retry or cancel at this time.

7, in the Sql Server 2005 installation directory, for example, in the C: Program Files Microsoft SQL ServerMSSQL.1MSSQLBinn folder, find the two files sqlservr.exe and sqlos.dll (renamed backup in advance) And then replace it with the other two Sql Server 2005 SP4 versions of the files in the attached file.

8. When the SQL Server 2005 installation is completed, the suite will not be started first, but the SQL Server service project will be forcibly stopped. (Enter computer management, select SQL Server Configuration Manager, prohibit the corresponding service items of SQL Server 2005)

9, then overwrite the two files backed up before, and then immediately put on the Sql Server 2005 SP4 patch.


10, after the installation of Sql Server 2005 SP4 patch immediately restart the computer, you can start the SQL Server 2005 management suite of tools properly.