Wednesday, January 28, 2009

SQL Server Management Studio not installed with Sql Server 2005 Installation

I came across this problem when trying to install Sql Server Management Studio and other client tools. Basically, for many different reasons, Management Studio and other client tools will not install after you've installed SQL Server 2005 server components. The error that is thrown is below -

Name: Microsoft SQL Server 2005 Tools Express EditionReason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Build version check:
Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.


A screen shot of this problem is here:



The problem here is basically that SQL Server 2005 installer seems to think that a higher version or something of SQL Server is already installed on this machine and therefore blocks the current installation by disabling the checkbox that could've made all our lives much easier.


sql-server-2005-management-studio-installation


As the obvious rectification step, I tried to find that missing prior installation of SQL Server but as expected, it was nowhere to be found and also for some reason this problem can't always be rectified by reinstalling SQL Server. So, we can't uninstall the previous version that SQL Server installer thinks is already there and we are stuck. So what gives? It turns out that we can set SKUUPGRADE to 1 while installing from the command prompt - E:\>setup.exe SKUUPGRADE=1 - This enables that silly checkbox to allow installation (or upgradation) of the client components. Below is how this command prompt looks on my system for reference -


sql-server-2005-management-studio-installation


Once you run the installer with SKUUPGRADE ON, you should be able to see the option to install SQL Server Management Studio in the installer. Below is a screen shot that shows how it looks now (please ignore the Integration Service thing as that's disabled in the picture for an entirely different reason) -


sql-server-2005-management-studio-installation


Now when you click Next, you should see the below -


/sql-server-2005-management-studio-installation


Now click "Install" button and install the client components! But why is it so, how would a normal user know that he needs to do it via command prompt with some flag, why isn't that flag available as some advanced installation option in UI itself  and why doesn't the error message provide some info about this possible (and in many cases, only) solution? Well, I've to say that Microsoft and specifically whoever designed this Sql Server 2005 installed must be [...fill this one yourself...]

11 comments:

  1. thanks, you're a wonderful human being. Cause this problem had me going for days...

    ReplyDelete
  2. Glad to be of help! Yeah, this Sql Server Management Studio installation issue bugged for quite a while and I had to resort to using Visual Studio for running queries before I finally figured this skuupgrade hack!

    ReplyDelete
  3. great tip. i just found your blog tonight, and i have been reading everything on here. i just like the approach you take and the way you describe it in your writing style.

    hope you continue to write some more stuff.

    thanks.

    ReplyDelete
  4. Very nice article. It really helped me a lot.

    ReplyDelete
  5. Wow, you are the man - saved the day :)

    ReplyDelete
  6. Very helpful aticle.Please keep writing upgrade things

    ReplyDelete
  7. Still wont work on Win7 though... i have retried a couple of times. please help.

    ReplyDelete
  8. You are a life saver. =) Thanks for the wonderful tip!

    ReplyDelete
  9. Hello, i would like to ask that what is the benefits of sql training, what all topics should be covered and it is kinda bothering me … and has anyone studies from this course http://www.wiziq.com/course/125-comprehensive-introduction-to-sql of SQL tutorial online?? or tell me any other guidance...
    would really appreciate help… and Also i would like to thank for all the information you are providing on sql training.

    ReplyDelete
  10. Really worked very well. Thanks!!

    ReplyDelete