Mentioned
In
|
 |
 |
 |
|
Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved. Terms
of Use |
Trademarks
You cannot install SQL Server 2005 on a server when the number of processors of the server is not a power of 2| Article ID | : | 954835 | | Last Review | : | July 8, 2008 | | Revision | : | 2.0 |
On This PageSYMPTOMSA server contains multiple processors. Additionally,
the
number of processors is not the power of 2. For example, the server has three
processors or six processors. Or the server has a triple-core processor. When you install Microsoft SQL Server 2005 on this
server, the installation fails.  Back to the top
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
SQLSetup Num_ 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. |
Back to the top WORKAROUNDTo work around this problem, use Method 1 if the server is running Windows Server 2003. If the server is running Windows Server 2008, use Method 2. Back to the top Method 1| 1. | Start the server by using a
number of processors
that is a power of 2. 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 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, select a number that is the power of 2,
and then click OK. | | f. | In the System Configuration Utility
dialog box, click OK. | | g. | 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://kbalertz.com/Feedback.aspx?kbNumber=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:
| 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 click OK. | | d. | Restart the server. |
|
Back to the top Method 2| 1. | Start the server by using a
number of processors
that is a power of 2. To do this, follow these steps:
| a. | Click Start, click
Run, type msconfig, and then click
OK. | | b. | In the System Configuration
dialog box, click the Boot tab. | | c. | On the Boot tab, click
Advanced options. | | d. | In the BOOT Advanced Options
dialog box, click to select the Number of processors check
box. | | e. | Under the Number of processors check box, select a number that is the power of 2, and then click OK. | | f. | In the System Configuration
dialog box, click OK. | | g. | 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://kbalertz.com/Feedback.aspx?kbNumber=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:
| a. | Click Start, click
Run, type msconfig, and then click
OK. | | b. | In the System Configuration
dialog box, click the General tab. | | c. | On the General tab, click
Normal startup, and
then click OK. | | d. | Restart the server. |
|
Back to the top STATUSMicrosoft
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. Back to the top MORE INFORMATIONThe SQL Server 2005 Setup program 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, install the
corresponding SQL Server 2005 service pack. Therefore, even if 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
integrated a specific SQL Server 2005 service pack. After 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, you can successfully install SQL Server 2005 Express Edition together with the integrated
service pack. To download SQL Server 2005 Express Edition of the
latest SQL Server 2005 service pack, visit the following Microsoft Web site:
Back to the top
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 |
Back to the top
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please
|
|
 |
|
 |
|
|
|
| |