Like yesterday, we had to install SQL Server 2005 Enterprise Edition on one more test box. There are two test boxes on which we are required to install all versions of SQL Server. The application team needs to check the compatibility of Tivoli Patch Management application on these instances. I must say the servers that we were given for installing SQL Server are really out of this world. Before clicking on setup.exe we know that it will fail for at least two attempts.
With the same thought in mind, we started the installation of SQL Server 2005 Enterprise Edition on one of those boxes. This time, the setup failed in the very beginning while checking Performance Monitor counters.
The System Configuration Check for Performance Monitor counter registry value has failed. For details, see How to: Increment the Counter Registry Key for Setup in SQL Server 2005, in the readme file or in SQL Server Books Online.
From the error message it was confirmed that some of the values related to Performance Monitor counters are missing. Opened up regedit.exe and navigated to HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib 09
Surprise ! Not some values were missing, this key did not have any values at all ! On a normal server, this key would have values as in the below screen shot.
Since the DBA team does not have permissions to modify this registry key, we have asked the System Administrators team to fix this. Most likely they will rebuild the performance counter library values as explained in this KB article. Till they complete this task, the DBA cannot go ahead with the SQL Server 2005 installation.
We have couple more installations to be done on these awesome twin servers, I am geared up for some more surprises.