SQL server 2005 install problem

 Post by Zak3 from msdn

I've the same problem on my Windows XP, and I've solved it.

 

Sharing my solution here:

1. [Start / Run... / regedit]

 

2. Find registry key [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]

    "Last Counter" : 5476

    "Last Help" : 5477

 

3. Because I am using Chinese Traditional Version, So I have to subkeys under [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]. One is [004], and another one is [009].

 

4. Open [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009\Counter] (Double Click It)

    You'll see a lot of strings here, just drag to the end of it (or press [Ctrl]+[End]), you probably see something like

"5466
   Workflows Persisted/sec"

      the value [5466] should match [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Counter]

 

     In my situation, 5466 matches the key, but I still get the error message. So, I check the other key [004].

 

5. Open [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\004\Counter]

     As above, double click on the [Counter] to see its value, and drag to the end. In my situation, the last value looks like

"7236
   Workflows Persisted/sec"

 

     So, I changed the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Counter] to match the value in [004\Counter]

    

6. Double Click on the [[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Counter], select decimal, and key in its value. In my situaion, I decided to use the value in [004\Counter], which is 7236.

 

    Now do the samething to the [Last Help]

 

7. Open [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009\Help] (Double Click It)

    You'll see a lot of strings here, just drag to the end of it (or press [Ctrl]+[End]), you probably see something like

"5333
ServiceModelService 3.0.0.0 performance counters"

      the value [5333] should match [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Help]

 

     In my situation, 5333 matches the key, but I still get the error message. So, I check the other key [004].

 

8. Open [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\004\Help]

     As above, double click on the [Help] to see its value, and drag to the end. In my situation, the last value looks like

"6033 傳輸傳送 I/O 作業的平均位元組長度基底。"

 

     So, I changed the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Help] to match the value in [004\Help]

    

9. Double Click on the [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Help], select decimal, and key in its value. In my situaion, I decided to use the value in [004\Help], which is 6033.

 

10. Done. Now restart the installer.

 

The point is check every node under [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib] to make sure the value right. That's how I solve it. Just for your reference.