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.
Additionally, an error message that resembles the following is logged in the
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:
Num represents a four-digit
number that increases for every installation of SQL Server 2005.
InstanceName represents the name of the instance of SQL
file is located in the following folder:
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.
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
SQL Server 2005 Express Edition is a stand-alone package
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
To download SQL Server 2005 Express Edition together with the
latest SQL Server 2005 service pack, visit the following Microsoft Web site: