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

Computer Shop News: As usual, 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 SQL Server 2005 standards, how can I use the SQL Server 2005 suite under Microsoft's latest Windows 8/Windows 8.1? The following small series will briefly introduce the use of 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 and select “Run the program without getting help if there is a compatibility problem”.

2. Select 64-bit installation
>

3. Select the service component you need to install

4. Select the built-in system account

< Br>

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

6. When Sql Server 2005 fails to start, do not click retry at this time or cancel.

7. In the Sql Server 2005 installation directory, for example, in C:\\Program Files\\Microsoft SQL Server\\MSSQL.1\\MSSQL\\Binn folder, find sqlservr.exe And sqlos.dll these two files (renamed under the backup in advance), and then replaced with the other two Sql Server 2005 SP4 version of the file in the attached file.

Attached: 64-bit version of sqlservr64.rar (corresponding 32-bit version of sqlservr32.rar) download

8, when the completion of SQL After Server 2005 is installed, the package is not started, but the SQL Server service project is forcibly stopped. (Enter computer management, select SQL Server Configuration Manager, prohibit the corresponding service project of SQL Server 2005)

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

(Click here to go to Microsoft officially download Sql Server 2005 SP4 patch)

10. After installing Sql Server 2005 SP4 patch, restart immediately The computer can start the SQL Server 2005 management tool suite normally.