Installation SQLServer2005 prompts the SQL Server service to fail to start

error Log

The following error occurred during installation: SQL Server 2005 installation error code 29503. Product: Microsoft SQL Server 2005--error 29503. The SQL Server service failed to start. For more information, see the topic "How to view SQL Server 2005 Setup log Files" and "Manually start SQL Server" in SQL Server Books Online. For more information, see the Picture:

　　Cause of the error

Multi-core CPUs cannot be installed when installing SQL SERVER2005 (because the SQL Server service cannot be started, resulting in an inability to install). The server that I installed is the HP Server 32 core Cpu,sql Server2005 cannot recognize multi-core, which causes the installation to fail. This problem does not exist with SQL Server 2008

Solution

1. Enter Msconfig at the command line and select ' BOOT '. INI '-' advanced option ', tick '/numproc ' to select the maximum 2 n-th (2/4/8), not exceeding the machine's total number of cores. Click OK, and then restart the computer to restart the computer settings to take effect. Look at the picture in detail:

2. Install SQL Server 2005, this time the service will not be able to start the error, should be very smooth.

3. Install service Package 3,sql Server SP3 patch.

4. Then enter Msconfig again, open the General tab, click Normal Startup on the General tab-load all device drivers and services, and then click OK.

5. Restart the computer, everything is done.