How to install Run SQL Server 2005 (and install SQL Server 2005 Express patching) under Win8.1 system

BO Master recently installed SQL Server2005 on Win8.1, unexpectedly often to error (for this blogger to reinstall the system)

It was later found that two files needed to be replaced on the Win8.1, which solved the problem successfully.

Http://www.ithome.com/html/win8/57118.htm

As normal, installing Microsoft's SQL Server 2005 suite under the win8/win8.1 system has a compatibility issue, and even after installation, the final result is that its service items will not start properly.

How can I use SQL Server 2005 suite in the latest Microsoft Windows8/windows 8.1 If a user-created project is not run and debugged according to the SQL Server 2005 standard? The following small part of the simple introduction of the use of file substitution method to resolve its service items can not start the temporary scheme. Of course, it is recommended to use more than SQL Server 2008 database, after all, now the SQL Server 2012 version has been released for more than a year.

To do this: choose to install the 64-bit database development suite as an example.

1, run the installation program, if there is a compatibility issue, 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 login database password

6, when SQL Server 2005 fails to start, this time do not first click Retry or Cancel.

7. Under the SQL Server 2005 installation directory, for example, under the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn folder, Locate the Sqlservr.exe and Sqlos.dll two files (under Advance Rename Backup), and then replace them with the other two SQL Server 2005 SP4 versions of the following attachments.

Attached: 64-bit version of Sqlservr64.rar (corresponding 32-bit version of Sqlservr32.rar) download

8. When you are finished installing SQL Server 2005, do not start the suite, but instead force the SQL Server service project to stop first. (Go to Computer Management, select SQL Server Configuration Manager, disable the corresponding service project for SQL Server 2005)

9 . then overwrite the 2 files previously backed up , then immediately hit the SQL Server 2005 SP4 patch.

The following content is added by blogger "Luzin":

Installing SQL Server 2005 Express on Win8.1 also needs to be patched:

http://www.microsoft.com/zh-cn/download/details.aspx?id=184

Postscript:

In comparison with the new operating system installed on the software for a long time, there will be an incompatible warning, when we have to do is to continue to install, if you encounter error prompts, please do not worry about canceling, looking for Niang or gu brother search, your problem others will certainly encounter and will have methods to provide.

Remember:

(1) Do not unworthy, that is: do not because of the emergence of incompatible with the idea of switching back to the low version of the operating system (such as win8.1 change back to Win7)!

(2) to Microsoft to give more confidence, this does not Microsoft in the first time on the WIN8 series operating system installed SQL2005 when the issue of the patch! We need to find out the cause of the problem and get some sense from it.

How to install Run SQL Server 2005 (and install SQL Server 2005 Express patching) under Win8.1 system