none
SQL Server 2008 R2 Express (installation on windows 7) RRS feed

  • 問題

  • Hi,

           I couldn't installed SQL Server 2008 R2 to VISTA, now I have upgrade to windows 7.

    If I want to install SQL Server 2008 R2 Express to my desktop, do I need to delete all SQL related files in desktop first ?

    2010年9月16日 上午 11:36

所有回覆

  • If you uninstalled sql and still have files left, yes have to clean them up. Should clean up registry too.
    2010年9月16日 下午 01:43
  • I had installed VS 2010 Ultimate, is it still need to clean up all SQL 's files?

    And, how to clean up registry ?

    2010年9月16日 下午 01:51
  • Don't have to clean up anything if you didn't uninstall sql from the box.
    2010年9月17日 上午 12:10
  • I got error and it close down the installation, why ? can't install SQL Server 2008 R2 CHT

     

    2010年9月20日 上午 04:12
  • Check details in installation log files.
    2010年9月20日 下午 02:10
  • Too many log files,

    Where is the log file of installation you mean ?

    And then what can I do after seeing the log files?

    2010年9月21日 上午 06:40
  • Error message usually contains log file path and name, have to check all of them in the folder then fix whatever they say.
    2010年9月21日 下午 01:17
  • I check the function of installation program.

    result is " 效能計數器登錄區一致性    失敗"

    你可以幫忙我嗎?

    2010年10月7日 上午 04:04
  • Have error in English? I don't have win7 to test.
    2010年10月7日 下午 01:24
  • Hi rmiao,

                My version is CHT (SQL server). You don't understand Chinese?

    2010年10月12日 下午 01:29
  • Not many references of this in Chinese out there.

    2010年10月13日 上午 12:29
  • What is the language of your operating system?


    Also, would you please help to check the following?
    [Region and Language]
       >> under the [Administrtive] tab
          >> What's the [Current language for non-Unicode programs]?


    -- Martin POON -- Software Architect -- SQL Server MVP, MCTS, MCITP ~~ http://msMVPs.com/blogs/MartinPOON
    2010年11月3日 下午 02:57
  •  My operation system is in traditional chinese. Can you help me to install SQL 2008 express?
    2010年11月26日 上午 06:51
  • [Warning] This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

    322756  (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows
     
    ===== My suggested solution follows.
     
    Start Registry Editor [ RegEdit.exe ], and locate the key [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib ] in the registry.
     
    You may found *some* of the following subkeys.
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\004 ]
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\009 ]
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\0404 ]
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\0804 ]
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\CurrentLanguage ]
    (Note that you may NOT find all of these subkeys.)
     
    For each subkey, double-click on the value [ Counter ], and scroll to the bottom. Obtain the largest *numeric* value that you found at the bottom of every [ Counter ] for \004, \009, \0404, \0804, \CurrentLanguage.
     
    Go back to the key [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib ], and double-click on the value [ Last Counter ]. Change the base to *decimal*, and update [value data] to the largest numeric value of [ Counter ] that you found in the previous step.
     
    Repeat these steps to obtain the largest value for [ Help ], and update the value of [ Last Help ].
     
    Close the Registry Editor, and try to install SQL Server afterwards.
     
    ===== For more information =====
    ~ How to manually rebuild Performance Counter Library values
    http://support.microsoft.com/kb/300956/en-us

    -- Martin POON -- Principal Consultant @ AppsGoGo.com -- SQL Server MVP, MCTS, MCITP ~~ http://msMVPs.com/blogs/MartinPOON ~~ http://www.MartinPOON.com
    2010年11月29日 下午 04:41
  • HELLO:

               I try to install SQL sever 2008 express with your answer . But it 's still not work.

    And, the error is same . In my computer , there are \009 and \0404 , \CurrentLanguage folders only.

     

    Stanley, waiting...

    2010年12月2日 上午 06:28
  • Are there other similar subkeys under [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib ] ?
    ( e.g., 0C04 )

    And, would you please clarify the language of your operating system?
    Is that Traditional Chinese - Taiwan?
    or, Traditional Chinese - Hong Kong SAR? 


    -- Martin POON -- Principal Consultant @ AppsGoGo.com -- SQL Server MVP, MCTS, MCITP ~~ http://msMVPs.com/blogs/MartinPOON ~~ http://www.MartinPOON.com
    2010年12月22日 下午 03:57
  • There are 009 and 0404, \currentlanguage.

    香港中文版(made in Taiwan)

    Is there subkey lost out already ?

     

    Stanley , please help me.

    2011年1月3日 下午 01:10
  • [Warning] This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

    322756  (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows
     
    ===== My suggested solution follows.
     
    Start Registry Editor [ RegEdit.exe ], and locate the key [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib ] in the registry.
     
    Assume that you have already got the following subkeys.
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\009 ]
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\0404 ]
    [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\CurrentLanguage ]
     
    For each subkey, double-click on the value [ Counter ], and scroll to the bottom. Obtain the largest *numeric* value that you found at the bottom of every [ Counter ] for \009, \0404, \CurrentLanguage.
     
    Go back to the key [ HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib ]
    - Create the registry subkey [ HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\Current Version\Perflib\004 ]
    - Create two registry entries of the Multi-String type: Counter, Help
    - Copy value to the registry entry [ HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\Current Version\Perflib\004\Counter ]
    - Copy value to the registry entry [ HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\Current Version\Perflib\004\Help ]
     
    Close the Registry Editor, and try to install SQL Server afterwards.
     
    ===== For more information =====
    ~ FIX: Error message when you install SQL Server 2008 Express edition on a computer that is running the Chinese Traditional version of Windows Vista for Hongkong: “Performance counter registry hive consistency”
    http://support.microsoft.com/kb/976231 


    -- Martin POON -- Principal Consultant @ AppsGoGo.com -- SQL Server MVP, MCTS, MCITP ~~ http://msMVPs.com/blogs/MartinPOON ~~ http://www.MartinPOON.com
    2011年3月18日 下午 01:18
  • Dear,

             In the last message, you said "Copy value to the registry entry [HKEY_LOCAL_MACHINE\SOFTWARE\

             Microsoft\Windows NT\Current Version\Perflib\004\Counter ]"

                    But you haven't said copy what value.

     

             And, YOU haven't  said what will you doing after "Obtain the largest *numeric* value in [Counter] of \009, \0404, \CurrentLanguage. "

                     Is it true like that : I got 2024 at the bottom of every [Counter] for \009, \0404, \CurrentLanguage.     Then do I need to copy "2024" to the registry entry of [...\Perfib\004\Counter] and [...\Perflib\004\Help ]

             Please complete your solution, Martin.

               


    Stanley Jiing Tay Wu
    2011年3月21日 上午 06:40
  • 1. Obtain what value at the bottom of every [Counter] for \009, \0404, \CurrentLanguage ? Are there 3 value at all ?

    2. How many value need to copy to \004 [Counter] and [Help] respectively?

    3. Do I need  to use copy and paste on in regedit and how to do it ?


    Stanley Jiing Tay Wu
    2011年5月17日 上午 03:37
  • Did you install .NET Framework 3.5 and Windows installer? Here is a link to the installation guide: http://blogs.msdn.com/b/petersad/archive/2009/11/13/how-to-install-sql-server-2008-r2-express-edition-november-ctp.aspx

     

    2011年7月13日 下午 02:55