SQL 2005 RTM service fails to start after new installation

IT

SQL 2005 RTM service fails to start after new installation

by Tuan Nguyen

I ran across this multiple times over the last two years or so. This issue started with the introduction of the AMD tri-core processors, and continued when Intel released the hexa-core processors. This only applies to SQL 2005 RTM or older, on processors that are not a power of 2 (or single core).

When you install SQL 2005 RTM, it will complete the install, but fail on the last step when it tries to start the service.

There are two fixes for this according to Microsoft, however only one is supported, therefore I will post that one.

First, uninstall SQL 2005 RTM, then reboot the server into the BIOS. In the CPU settings, set the number of cores to a power of two, or to single core. Reboot into Windows Server and initiate the install of SQL again. It will be successful this time, and allow the service to start. Now install SP2 or SP3 for SQL 2005, and reboot back into the bios. Set the cores to all again.

Reboot into Windows, and your SQL 2005 installation should be functional.

 

Credit Microsoft KB: http://support.microsoft.com/kb/954835/en-us

More About the Author

Tuan Nguyen

Systems Engineer
Microsoft Exchange 2013: OWA Signature Error In Microsoft Exchange, you may have received these error messages: “The signature is too big. Please try a smaller format.” ...
ActiveSync Failing When testexchangeconnectivity.com Passes? I came across this issue recently, where we migrated from a hosted Exchange 2010 server to an on-site Exchange 2013 server and ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072