Installing SQL Management Studio 2008 Express


When installing SQL Express 2008, you may get the following error if you already have VS 2008 installed:

Rule “Previous releases of Microsoft Visual Studio 2008” failed.

A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008.

image

I’ve read a load of blogs about this issue, but none of them solved the problem that I was having, as I already had VS 2008 SP1 installed.

Galin Iliev’s excellent blog post comes close but doesn’t quite hit the bullseye (although I believe that his solution would probably work as well). The problem is that I have Visual Studio 2008 database edition installed as well. So, from Galin’s post, I found that the following registry key stores version settings of VS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0

Going in there, I see not one, but three sub-keys: –

image

I’ve annotated the above with what I guess the different keys represent.

Inside each of those keys are a load of properties, one of which is named SP. VSTD is set to 1 (correctly), but VSDB and VSDBGDR are both set to 0.

Solution: Ensure that all three keys have the “SP” value set to 1.

It appears that the SQL installer expects all of them to be set to 1 otherwise it won’t install…

P.S. Probably best to set them back to 0 after the install 🙂

Advertisements

One thought on “Installing SQL Management Studio 2008 Express

  1. If you are trying to install SQL-2008 and you also have visual studio 2008 installed with service pack one (SP1) and get the error

    “A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008”

    Then welcome to the Microsoft beta testing program even if you purchased the faulty software.

    With XP the most common solution seem to be renaming the registry key
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0
    And replacing ‘9.0’ with ‘9.0Old’ however this does not solve the problem if you are using windows 7 and the only solution I managed to find that worked was to uninstall VS2008 and all the components and to then install SQL-2008 and finally reinstall VS2008.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s