SQL Server 2008 R2 Installation Issue : ” The configuration registry key is invalid”

Hi Folks,

Before some time I was installing SQL Server 2008 R2 EE 32-bit on Windows Server 2003 SP2 SE (32-bit) but it failed on final installlation wizard with error ” The configuration registry key is invalid”.  I had all the pre-requisite i.e. s/w and h/w level. I looked in to the “detail.txt” file of the installation to look  deep in this issue. I found below info in that file:-

2011-12-21 10:42:45 Slp: PerfCounter calling lodctr: ‘C:\Program Files\Microsoft SQL Server\100\DTS\Binn\perf-MsDtsServer100DTSSVCPERF.INI’
2011-12-21 10:42:45 Slp: Prompting user if they want to retry this action due to the following failure:
2011-12-21 10:42:45 Slp: —————————————-
2011-12-21 10:42:45 Slp: The following is an exception stack listing the exceptions in outermost to innermost order
2011-12-21 10:42:45 Slp: Inner exceptions are being indented
2011-12-21 10:42:45 Slp:
2011-12-21 10:42:45 Slp: Exception type: Microsoft.SqlServer.Configuration.Sco.ScoException
2011-12-21 10:42:45 Slp:     Message:
2011-12-21 10:42:45 Slp:         The configuration registry key is invalid.
2011-12-21 10:42:45 Slp:        
2011-12-21 10:42:45 Slp:     Data:
2011-12-21 10:42:45 Slp:       WatsonData = netfxperf.dll@OpenPerformanceData@CollectPerformanceData@ClosePerformanceData
2011-12-21 10:42:45 Slp:       DisableRetry = true
2011-12-21 10:42:45 Slp:     Inner exception type: System.ComponentModel.Win32Exception
2011-12-21 10:42:45 Slp:         Message:
2011-12-21 10:42:45 Slp:                 The configuration registry key is invalid.
2011-12-21 10:42:45 Slp:                
2011-12-21 10:42:45 Slp:         Stack:
2011-12-21 10:42:45 Slp:                 at Microsoft.SqlServer.Configuration.Sco.PerformanceCounter.LoadPerformanceCounter(String symbolInstallPath, String counterPrefixServiceName)
2011-12-21 10:42:45 Slp:                 at Microsoft.SqlServer.Configuration.Sco.PerformanceCounter.RegisterPerformanceCounterCore(String libraryFileName, String openFunction, String collectionFunction, String closeFunction, String symbolInstallPath, String counterPrefixServiceName)
2011-12-21 10:42:45 Slp:                 at Microsoft.SqlServer.Configuration.Sco.PerformanceCounter.RegisterPerformanceCounter(String libraryFileName, String openFunction, String collectionFunction, String closeFunction, String symbolInstallPath)
2011-12-21 10:42:45 Slp: —————————————-
2011-12-21 10:57:33 Slp: User has chosen to retry this action

 To resolve this issue there was a need to rebuild the performance counters in windows server. To rebuild all Performance counters including extensible and third-party counters in Windows Server 2003, type the following commands at a command prompt. Press ENTER after each command.
cd\windows\system32
lodctr /R

 Notes: 
/R is uppercase. You must have administrative rights on the computer to successfully perform this command.
On a computer that is running a 32-bit edition of Windows XP, the Lodctr /R:<filename> command is the standard method to restore performance counter registry strings and information by using a file name. 

After Rebuild of Performance Counters, uninstalled the failed Default instance and Installed SQL server 2008 R2 and installation completed successfully.

Please refer below link for more inofrmation to rebuild Performance Counter Library values:-

http://support.microsoft.com/kb/300956 

Hope it will help someone.

Advertisements

2 Responses

  1. Dude!!! Helped me out 100%. I was about to throw the machine out the window. I had my doubts trying this due to the fact I am on windows 7 pro and not Server as you mentioned above. However running this let me un-install sql server 2008. Installing or Removing you will get this same error it seems and this little trick will fix the error. Thanks a ton man!

  2. You’re a life saver. Simple solution to a complicated problem. Thank you so much.

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

%d bloggers like this: