SQL 2000 cluster installation will fail if number of CPUs on a box are not in power of 2

This post is dedicated to one of my customers who I was working with, the other day. It was a simple yet tricky scenario where we were trying to install the SQL server 2000 cluster.

Installation started  and the passive node was patched successfully. While upgrading the binaries of active node everything was fine but as soon as it tried to start the SQL server to build the catalogues, it failed. After that it was failing to come online without any error in SQL error logs.

We checked the SQL setup logs from location c:windows and the file was sqlsp.log (for SQL 2000) and found the error:

14:58:07 Upgrading databases on instance ‘MSSQLSERVER’ 14:58:07 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Service MSSQLSERVER  14:58:07 Process Exit Code: (0) 14:58:07 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 6 -Service MSSQLSERVER  14:58:07 Process Exit Code: (0) 14:58:07 C:DOCUME~1ADMINI~1LOCALS~1TempSqlSetupBinscm.exe  -Silent 1 -Action 1 -Service MSSQLSERVER   -StartupOptions -T4022 -T4010 -m 15:13:12 Process Exit Code: (1460) This operation returned because the timeout period expired.
15:24:47 A service control operation failed for the MSSQLSERVER service: 1460 This operation returned because the timeout period expired.
15:25:00 An error occurred starting the service to build system catalogs. 15:25:00 Action CleanUpInstall: 15:25:00 Installation Failed.

Did some research and found the issue to be due to no. of processors not the power of 2. Followed the action plan which was very famous one and was blogged at many places :- http://blogs.msdn.com/b/sqlserverfaq/archive/2009/05/27/info-sql-2000-msde-installation-will-fail-if-you-have-number-of-cpus-on-a-box-which-is-not-in-power-of-2.aspx .

The action plan to resolve the issue was to add -T3601 and -T3603 in SQL startup parameters

and the issue was resolved.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s