6-Core CPU causes "Unable to start service" error when installing SQL2005

Monday Install SQL server2005 on the newly purchased IBM3650M3 server

When installed in half, the report "prompt: SQL Server service failed to start. Wrong

There are several operating system versions and several versions of sql2005 that have been changed in this step. It took a day and a half to find out why,
For the general XDZM sister do not make me the same mistake, now the solution is public!

Later only to figure out, is the CPU core reason, because I this IBM x3650m3 is new, the CPU is six-core,

Reason:

When installing SQL 2005 Standard Edition (no more than four CPUs) and Enterprise Edition (unlimited),

The total number of cores of the CPU must be 2 of the n-th. That is, the core number is 1,2,4,8,16,32, and so on.

Because the Server core number is 6x2=12, it cannot be installed properly.

When the core number is changed to 8 o'clock, the installation completes successfully.

Workaround:

Change the core number of the system app before installing.

Start ==> run ==> input msconfig, open ' system Configuration Utility ',

Select ' BOOT '. INI '---' Advanced options ', tick the '/numproc ' value to select the maximum of 2 of the n-th square.

After restarting, SQL Server 2005 is installed properly.

After the installation is complete, hit the full SQL 2005 SP3 patch.

Then remove the '/numproc ' check.

After restarting the system, you can run SQL Server 2005 normally with all physical cores.

6-Core CPU causes "Unable to start service" error when installing SQL2005