Help and Support
 

powered byLive Search
Article ID: 954835 - Last Review: March 18, 2009 - Revision: 4.0

On a computer that has a multicore processor, if the ratio of logical processors to physical sockets is not a power of 2, you cannot install SQL Server 2005

On This Page

SYMPTOMS
Consider the following scenario. You try to install Microsoft SQL Server 2005 on...

Consider the following scenario. You try to install Microsoft SQL Server 2005 on a computer that has a multicore processor. The ratio between logical processors and physical sockets is not a power of 2. For example, the computer has a single socket together with a triple-core processor. In this scenario, you cannot install SQL Server 2005.
When the installation fails, the following error message is logged in the Summary.txt file:
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."
Note The Summary.txt file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG
Additionally, an error message that resembles the following is logged in the SQLSetupNum_InstanceName_SQL.log file:
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Wed Jun 18 08:32:41 2008
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Wed Jun 18 08:32:41 2008
Unable to start service (1053)
Error Code: 0x8007041d (1053)
Windows Error Text: The service did not respond to the start or control request in a timely fashion.
Source File Name: sqlsetuplib\service.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: sqls::Service::Start
Source Line Number: 316
Notes
  • Num represents a four-digit number that increases for every installation of SQL Server 2005. InstanceName represents the name of the instance of SQL Server 2005.
  • The SQLSetupNum_InstanceName_SQL.log file is located in the following folder:
    %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
  • This problem does not occur in Microsoft SQL Server 2008.

WORKAROUND
To work around this problem, before you install SQL Server 2005, temporarily cha...

To work around this problem, 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, use one of the following methods, as appropriate.

Method 1: Windows Server 2003

  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.
  3. Install the latest service pack for SQL Server 2005.

    For more information about how to obtain the latest SQL Server 2005 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
    913089  (http://support.microsoft.com/kb/913089/ ) How to obtain the latest service pack for SQL Server 2005
  4. Restart the server by using all the processors. To do this, follow these steps:
    1. Click Start, click Run, type msconfig, and then click OK.
    2. In the System Configuration Utility dialog box, click the General tab.
    3. On the General tab, click Normal Startup - load all device drivers and services, and then click OK.
    4. Restart the server.

Method 2: Windows Server 2008

  1. To change the number of logical processors in Windows Server 2008, follow these steps::
    1. Click Start, click Run, type msconfig, and then click OK.
    2. In the System Configuration dialog box, click the Boot tab.
    3. On the Boot tab, click Advanced options.
    4. In the BOOT Advanced Options dialog box, click to select the Number of processors check box.
    5. Under the Number of processors check box, click 1, and then click OK.
    6. In the System Configuration dialog box, click OK.
    7. Restart the server.
  2. Install SQL Server 2005.
  3. Install the latest service pack for SQL Server 2005.

    Note You must install SQL Server 2005 Service Pack 2 (SP2) or a later service pack on Windows Server 2008.

    For more information about how to obtain the latest SQL Server 2005 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
    913089  (http://support.microsoft.com/kb/913089/ ) How to obtain the latest service pack for SQL Server 2005
  4. Restart the server by using all the processors. To do this, follow these steps:
    1. Click Start, click Run, type msconfig, and then click OK.
    2. In the System Configuration dialog box, click the General tab.
    3. On the General tab, click Normal startup, and then click OK.
    4. Restart the server.

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that ar...

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in SQL Server 2005 Service Pack 1.

MORE INFORMATION
SQL Server 2005 Setup does not integrate any SQL Server 2005 service packs. To i...

SQL Server 2005 Setup does not integrate any SQL Server 2005 service packs. To install SQL Server 2005 to a specific service pack level, you must install the release version of SQL Server 2005 first. Then, you must install the required SQL Server 2005 service pack. Therefore, although this problem is fixed in SQL Server 2005 Service Pack 1 (SP1), you still cannot install SQL Server 2005.

SQL Server 2005 Express Edition is a stand-alone package that integrates a specific SQL Server 2005 service pack. When you perform a fresh installation of SQL Server 2005 Express Edition that integrates a specific SQL Server 2005 service pack, SQL Server 2005 Express Edition is running at that service pack level. Therefore, in the scenario that is mentioned in the "Symptoms" section, you can successfully install SQL Server 2005 Express Edition together with the integrated service pack.

To download SQL Server 2005 Express Edition together with the latest SQL Server 2005 service pack, visit the following Microsoft Web site:
http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx (http://www.microsoft.com/Sqlserver/2005/en/us/express.aspx)

APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB954835
 
Provide feedback on this information
Did this information solve your problem?
Yes
No
I don't know
Was this information relevant?
Yes
No
What can we do to improve this information?
To protect your privacy, do not include contact information in your feedback.

Article Translations

 

Related Support Centers