How to install and run SQL Server 2005

As a normal situation, there will be compatibility problems when installing Microsoft SQL Server 2005 suite under Win8/Win8.1 system. Even after installation, the final result is to cause its service. The item does not start properly.

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? It is a brief introduction to 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

5. Select the mixed mode login and enter the password for logging 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, and then immediately put on the Sql Server 2005 SP4 patch.

10, after installing the Sql Server 2005 SP4 patch, restart the computer immediately, you can start the SQL Server 2005 management tool suite.