"Performance Monitor Counter Requirement" When installing SQL Server 2005 Express

Problem when install SQL Server 2005 Express:

Performance Monitor Counter Requirement

 

image

Click "Messages..."

image

Solution:

How to: Increment the Counter Registry Key for Setup in SQL Server 2005

Setup Configuration Checker (SCC) in Microsoft SQL Server Setup verifies the value of the counter registry key before SQL Server installation begins. If SCC cannot verify the existing registry key, or if SCC cannot run the lodctr.exe system program, the SCC check will fail, and Setup will be blocked.

Incorrectly editing the registry can severely damage your system. Before making changes to the registry, we recommend that you back up any valued data on the computer.

To manually set the increment for the counter registry key

  1. On the Microsoft Windows 2003 or Windows XP desktop, click Start, click Run, type regedit.exe in Open, and then click OK. On Windows 2000, use regedt32.exe The Registry Editor launches.

  2. Navigate to the following registry key:

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]

image

"Last Counter"=dword:00000ed4 (5276)

"LastHelp"=dword:00000ed5 (5277)

3 The "Last Counter" value from the previous step (5276) must match the maximum value of the "Counter" key from "Perflib\009" in the following registry key, and the "Last Help" value from the previous step (5277) must match the maximum value of the "Help" key from "Perflib\009" in the following registry key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009]

Tip : If your OS is Chinese , match "Perflib\004" ,not "Perflib\009".

Note that 009 is an example from the English language. The "Last Counter" and "Last Help" values are dynamically assigned by Windows; they will vary from machine to machine.

4 If necessary, modify the value for the "Last Counter" and "Last Help" values in the "\Perflib" key: right-click Last Counter or Last Help in the right-hand pane, click Modify, click Base = "Decimal," set the value in Value data, and then click OK. Repeat for the other key, if necessary, and then close the Registry Editor.

5 Run SQL Server Setup again.

image

 

More reference:

http://technet.microsoft.com/en-us/library/ms143215.aspx

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=356308&SiteID=1

http://forums.microsoft.com/MSDN-CHT/ShowPost.aspx?PostID=633015&SiteID=14

posted @ 2007-08-22 12:59  emanlee  阅读(3263)  评论(0编辑  收藏  举报