Monday, January 9, 2012

Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1. Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.

SQL 2K8 R2 installation fails with Visual Studio error even I don’t have VS installed at all on my machine!!!

I have encountered an interesting and time consuming issue last week. I was trying to install SQL 2k8 R2 on one of my servers. Installation went fine upto some extent, it installed DB Engine and other stuff but while installing “SQL Server Client Tools” it failed throwing below error:

“Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.”

I noticed “Visual Studio 2008 Shell Isolated Mode Redistributable” was installed on machine and noticed it was already updated to SP1. I re-installed this one also from this link. Now I tried installing SQL Server Client Tools again but I received the same above error.

Then I found solution in this MSDN post. We need to make some changes to registry in order to proceed with SQL installation as mentioned below.

If you have a 64-bits computer, you need to check the following registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0\RED\1033

and ensure that the SP and SPIndex values are 1 and that the SPName is SP1

also we need to make changes to following registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033

ensure that the SP and SPIndex values are 1 and SPName value is SP1. The SP and SPIndex values were 0 and the SPName was RTM on my machine. I changed them to 1 and SP1 respectively and then tried installing client tools and installation went successfully.

Thanks

29 comments:

  1. Thanks a lot,
    Had the same problem. Now it works.

    ReplyDelete
    Replies
    1. Glad it helped you to solve the problem. Thanks!!

      Delete
  2. Thanks, it is really helpful.

    ReplyDelete
    Replies
    1. Glad it helped you to solve the problem. Thanks!!

      Delete
  3. Glad it helped you to solve the problem. Thanks!!

    ReplyDelete
  4. Thank you soooo much!

    ReplyDelete
  5. THANK YOU!! Saved me hours of headache!

    ReplyDelete
  6. Thanks for your post...
    I've been trying to install sql server mgmt tool the whole day after the upgrade...

    ReplyDelete
  7. when i go to registry key , how i change the value into 1?

    ReplyDelete
    Replies
    1. if you rightclick on it you will find or else double click it and check

      Delete
  8. Great! Thanks! I used this and it worked really well,

    REG ADD "HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033" /V "SPIndex" /T REG_DWORD /D 1 /F
    REG ADD "HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033" /V "SPName" /T REG_SZ /D "SP1" /F

    ReplyDelete
    Replies
    1. Sorry - cut & paste error, some missing keys.

      REG ADD "HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0" /V "SP" /T REG_DWORD /D 1 /F
      REG ADD "HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0" /V "SPIndex" /T REG_DWORD /D 1 /F
      REG ADD "HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033" /V "SP" /T REG_DWORD /D 1 /F
      REG ADD "HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033" /V "SPIndex" /T REG_DWORD /D 1 /F
      REG ADD "HKLM\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033" /V "SPName" /T REG_SZ /D "SP1" /F

      Delete
  9. Thanks!! You awesome!!

    ReplyDelete
  10. Many Thanks! I had tried various remedies to this problem that had all ended in failure and frustration until I came to this blog. Finally, SUCCESS!

    Thanks again-

    ReplyDelete
    Replies
    1. I'm glad it helped you. Welcome!!

      Delete
    2. Thanks a lot...I was lost and I found the light :-)

      Delete
  11. WOW, tnx a lot!!!!

    ReplyDelete
  12. Thank you
    It is working now after trying your suggestion

    ReplyDelete
  13. Do I need to change those registry entries back after the install?

    ReplyDelete
  14. Thanks. It is a quite stupid bug from Microsoft, why do they need to check that why I install the SSMS ?? Someone needs to be kicked in the ass.

    ReplyDelete
  15. It Worked!!! thanks a lot (from Jboy Flaga :) )

    ReplyDelete