Announcement

Collapse
No announcement yet.

FIX: Error "Performance Monitor Counter Requirement" when installing SQL 2005 Express

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • FIX: Error "Performance Monitor Counter Requirement" when installing SQL 2005 Express

    You'd face this error commonly when installing MSSQL 2005 Server, mostly in Express edition installations : "Performance Monitor Counter Requirement (Error)"

    Here's a brief information on the error :

    Setup Configuration Checker (SCC) in Microsoft SQL Server Setup verifies the value of the counter registry key before SQL Server installation begins. It scans the computer where Microsoft SQL Server 2005 will be installed. The SCC checks for conditions that prevent a successful SQL Server installation. Before Setup starts the SQL Server 2005 Installation Wizard, the SCC retrieves the status of each check item, compares the result with required conditions, and provides guidance for removal of blocking issues. All of the SCC check items are network enabled; checks can run on a local computer, as well as in remote and cluster situations.

    If SCC cannot verify the existing registry key, or if it can't run the lodctr.exe system program, then the SCC check will fail, and Setup will be blocked from proceeding further.

    Follow these steps to manually set the increment for the counter registry key & to overcome this error & proceed further with the SQL Server installation :

    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 appliction launches.

    2.Navigate to the following registry key:
    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]
    "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]
    Note : 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. Restart the machine for the changes to come into effect.

    6. Run SQL Server Setup again, this time it won't fail
    Rock _a.k.a._ Jack Daniel

    Follow eUKhost on Twitter || Join eUKhost Community on Facebook

  • #2

    This is great stuff Rock.

    I don't think that any one has realized the reason to post this fix here. We have searched many forums on Google without any solution to the error. We are one of few who has them.

    If you search with "Performance Monitor Counter Requirement" you will find this thread to be the first one with a solution (Just below Microsoft without a solution).
    Martin
    Chief R & D Officer.

    - -

    Comment


    • #3
      How to determine max value? max counter and max help?

      How to determine max value? max counter and max help? There's a long string of numbers under Perflib\009

      Many Thanks!

      Comment


      • #4
        Originally posted by normanfung View Post
        How to determine max value? max counter and max help? There's a long string of numbers under Perflib\009

        Many Thanks!
        There are no such values under standard server configurations. I've checked this on several machines running all versions of Microsoft Windows 2003. Are you using any other one in particular?
        Rock _a.k.a._ Jack Daniel

        Follow eUKhost on Twitter || Join eUKhost Community on Facebook

        Comment


        • #5
          I actuall had this happen after I had upgraded my Web Platform Installer version:2.0 while attempting to download & install SQL Server 2008 Express SP1 on my XP Pro SP3 system

          I want to make sure I understand what you are saying. I have included a zip file of the values from my \preflib\009 Hive: Which one of the values should I consider to be the maximum value?

          If the Last Value for this counter is here please identify and let us know what the correct value (if any) it should be in order to help fix this problem.

          thanks in advance . . .

          TomJ . .


          Attached Files

          Comment


          • #6
            Originally posted by tjdarth View Post
            I actuall had this happen after I had upgraded my Web Platform Installer version:2.0 while attempting to download & install SQL Server 2008 Express SP1 on my XP Pro SP3 system

            I want to make sure I understand what you are saying. I have included a zip file of the values from my \preflib\009 Hive: Which one of the values should I consider to be the maximum value?

            If the Last Value for this counter is here please identify and let us know what the correct value (if any) it should be in order to help fix this problem.

            thanks in advance . . .

            TomJ . .


            Hi Tom,

            Could you ensure that you're checking the values in the correct registry path?
            ie: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]


            If your 009 key is empty, follow these steps:

            Changing the value of: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Counter]

            to: 5276 decimal (hex 0x0000149c)

            Changing the value of: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Help]

            to: 5277 decimal (hex 0x0000149d)

            Let me know if that helps, good luck..
            Rock _a.k.a._ Jack Daniel

            Follow eUKhost on Twitter || Join eUKhost Community on Facebook

            Comment


            • #7
              Thanks Rock for the quick response. After finding MY missplaced glasses last nite, I went back and indeed found the 'Last Counter/Last Help' values under \preflib as you originally stated. Ichanged both values to '1846/1847' respectively. I also went on a little snoopying venture and found that 'Web Platform Installer' installed a new instance of SQLEXPRESS from the SQL Server 2008 EXPRESS SP1 appl, instead of updateing my existent SQLExpress2008! Now I need to find a way to correct that problem and see if I can still have access my SQL Databases.

              Thanks again for all of your help!!

              TomJ . . .

              Comment


              • #8
                Originally posted by tjdarth View Post
                Thanks Rock for the quick response. After finding MY missplaced glasses last nite, I went back and indeed found the 'Last Counter/Last Help' values under \preflib as you originally stated. Ichanged both values to '1846/1847' respectively. I also went on a little snoopying venture and found that 'Web Platform Installer' installed a new instance of SQLEXPRESS from the SQL Server 2008 EXPRESS SP1 appl, instead of updateing my existent SQLExpress2008! Now I need to find a way to correct that problem and see if I can still have access my SQL Databases.

                Thanks again for all of your help!!

                TomJ . . .
                You're most welcome, Tom Glad that your issue has been sorted out..

                The recent MS baby; 'web platform installer' is indeed a pain in the neck, leaving the installer annoyed & out of choices Good luck..
                Rock _a.k.a._ Jack Daniel

                Follow eUKhost on Twitter || Join eUKhost Community on Facebook

                Comment


                • #9
                  You rock!!

                  This post has helped me in my last breath of finishing my project. Thanks a lot ROCK!!
                  Spencer T.
                  ||

                  Comment


                  • #10
                    Originally posted by Spencer View Post
                    This post has helped me in my last breath of finishing my project. Thanks a lot ROCK!!
                    You're welcome, Spencer I'm glad this thread has helped many

                    It's always been a pleasure sharing ideas for me, which I'll continue to do so in the time to come.. Good luck
                    Rock _a.k.a._ Jack Daniel

                    Follow eUKhost on Twitter || Join eUKhost Community on Facebook

                    Comment


                    • #11
                      This rocks.

                      I was stuck for many days, till I found this thread.

                      Life saver.

                      Comment


                      • #12
                        Originally posted by dnayak View Post
                        This rocks.

                        I was stuck for many days, till I found this thread.

                        Life saver.
                        You're most welcome
                        Rock _a.k.a._ Jack Daniel

                        Follow eUKhost on Twitter || Join eUKhost Community on Facebook

                        Comment


                        • #13
                          Please help!

                          Hello comunnity. I want to install Windows SQL Server 2008 but i canīt because of the error describe in this thread.

                          I have do the solutions but the error continues when i try to install.

                          What is the problem?


                          "PerfMonCounterNotCorruptedCheck

                          Checks if existing performance counter registry hive is consistent."


                          Thanks.

                          Sorry about my english.

                          Comment


                          • #14
                            Originally posted by jonny_sig View Post
                            Hello comunnity. I want to install Windows SQL Server 2008 but i canīt because of the error describe in this thread.

                            I have do the solutions but the error continues when i try to install.

                            What is the problem?


                            "PerfMonCounterNotCorruptedCheck

                            Checks if existing performance counter registry hive is consistent."


                            Thanks.

                            Sorry about my english.
                            Hi,

                            Did you try running this command on the machine you want to install the SQL server on?

                            lodctr /R:PerfStringBackup.INI

                            Please try that & let us know if the problem persists..
                            Rock _a.k.a._ Jack Daniel

                            Follow eUKhost on Twitter || Join eUKhost Community on Facebook

                            Comment


                            • #15
                              Yes i try.

                              But the error still there. :S


                              Thanks

                              Comment

                              Working...
                              X