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

  
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 installer, if there is a compatibility problem, select "Run the program without getting help"
2, select 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 for logging in to the database
6. When Sql Server 2005 cannot be started, do not 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 use The other two Sql Server 2005 SP4 versions of the files in the following annex are replaced.
8, when the completion of SQL Server 2005 installation, first do not start the kit, but first force the stop of the SQL Server service project. (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, and then immediately put on the Sql Server 2005 SP4 patch.
10. After installing the Sql Server 2005 SP4 patch, restart the computer immediately and start the SQL Server 2005 management tool suite.

Copyright © Windows knowledge All Rights Reserved