Showing posts with label SQL 2005 Server. Show all posts
Showing posts with label SQL 2005 Server. Show all posts

Tuesday, February 28, 2012

Error installing SQL Server 2005 on a Server with Multicore Processor

A counterpart had flagged out that he has hit a roadblock while setting up SQL 2005 server in a clustered environment.
An error as below was found when the installation failed

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."

It was found that is an issue related to the number of cores in a CPU
The below was done to work around the issue on Windows 2003  and complete the installation

1.            To change the number of logical processors in Windows Server 2003, follow these steps:
a.            Click Start, click Run, type msconfig, and then click OK.
b.            In the System Configuration Utility dialog box, click the BOOT.INI tab.
c.             On the BOOT.INI tab, click Advanced Options.
d.            In the BOOT.INI Advanced Options dialog box, click to select the /NUMPROC= check box.
e.            In the list that is next to the /NUMPROC= check box, click 1, and then click OK.
f.             In the System Configuration Utility dialog box, click OK.
2.            Restart the server.
3.            Install SQL Server 2005.
4.            Install the latest service pack for SQL Server 2005.
5.            Restart the server by using all the processors. To do this, follow these steps:
a.            Click Start, click Run, type msconfig, and then click OK.
b.            In the System Configuration Utility dialog box, click the General tab.
c.             On the General tab, click Normal Startup - load all device drivers and services, and then clickOK.
d.            Restart the server.

More information of methods of workaround can be found in this KB from Microsoft