MSSQL2005 is the official release of the MSSQL database server software, the software set database management and services as a whole, in the MSSQL series version, 2005 is a more classic software; So many users still use the MSSQL2005 server under the WIN8 system, However, some users in the WIN8 system after the installation of MSSQL2005, the failure to start service, for the problem we apply how to solve it? The following small series to provide you with the solution!
Solving method
1. Install any version of SQL Server 2005 normally.
2, install to the SQL Server service when prompted to start service failure, here is the key, download the two attachments in this article, which is SP4 (2005.90.5000.0) version of the Sqlservr.exe and Sqlos.dll. 32-bit download sqlservr32.rar,64 bit download Sqlservr64.rar.
3, your binn, first backup the next sqlservr.exe, and then extract the corresponding sqlservr.exe and sqlos.dll copy to the inside overwrite the original file, such as "C:Program FilesMicrosoft SQL Servermssql.1mssqlbinn ".
4, click "Retry", installation continue, installation program installed successfully.
5, after the installation, stop the SQL Server service, the backup of the Sqlservr.exe file back (otherwise SP4 installer thought you have applied SP4 patch), and then immediately SP4 patch. (Do not run SQL any software until this time)
6, after the installation of SP4 patch, SQL Server is running normally.
Through the above method we can solve the problem of mssql2005 server installation failure, because many software now use MSSQL database, so MSSQL server when our computer common installation program, when you are in the WIN8 system can not start the problem, then quickly try the method!