Recently I was undertaking an upgrade going from SQL Server 2000 32 Bit to SQL Server 2005 64 Bit on Windows Server 2003 R2 64 Bit. In the preparation for the migration, installations of SQL Server 2005 proved to be a little troublesome. At first given the Installation in a test environment went smoothly had me thinking what is causing the installation process to error with the following error:
“Error Code: 0x8007041d (1053)
Windows Error Text: The service did not respond to the start or control in a timely fashion
Where to start looking to resolve this issue? Finding this KB article – kb954835 I went looking at the system resources on the server I was performing the installation on.
Sometimes More Power is not always a good thing. Having 48 processors available, caused the installation process to fail. Given that SQL Server 2005 is 9 years old, the support for multiple cores is not available.
Follow the steps in the KB to reduce the startup parameters of the server to a single core to allow for the installation of your SQL Server 2005 Instance. Ensure you apply SP4 and make sure that Hyper-Threading is not enabled.
Change the startup parameters again to allow for the full complement of cores to be available and restart your server. Ensure that your newly installed instance of SQL Server starts up after the server restart before you look at creating or migrating any databases into the new environment.
Look at upgrading your Windows version and SQL Server Version to a minimum of 2008 R2 to be able to cater for the resources available of your server and be utilising supported versions.
Leave a Reply