1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

SQL 2005 Installation - number of CPUs is not a power of 2

Friday, 03 January 2014 04:58

Written by Pranesh Soundarrajan

Print E-mail

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."

I tried to start the services manually, service did not respond properly and did not leave any traces on the failure.

Upon further analysis I found the below information in the Microsoft KB article.

In our environment we had 3 CPU’s and physical CPU’s were not a power of 2.

To resolve the error, I have followed the below steps.

Before you install SQL Server 2005, temporarily change the number of logical processors to one. This makes the computer appear to be a single-processor system, and SQL Server 2005 is installed successfully. To do this, follow these steps:

  1. To change the number of logical processors in Windows Server 2003, follow these steps:
    1. Click Start, click Run, type msconfig, and then click OK.
    2. In the System Configuration Utility dialog box, click the BOOT.INI tab.
    3. On the BOOT.INI tab, click Advanced Options.
    4. In the BOOT.INI Advanced Options dialog box, click to select the /NUMPROC= check box.
    5. In the list that is next to the /NUMPROC= check box, click 1, and then click OK.
    6. In the System Configuration Utility dialog box, click OK.
    7. Restart the server.
  2. Install SQL Server 2005.

 

 

After changing the logical processor to ‘1’, installation was successful.

 

Please don’t forget to change the logical processor count to original value after the installation else you will end up in performance bottleneck.

Additional information can be found in the following KB article:-  http://support.microsoft.com/kb/954835/en-us

SQL 2005 Installation - number of CPUs is	 not a power of 2