sql server management studio on windows vista
posted by: Ralf Rottmann | posted @ Monday, March 10, 2008 11:42 AM | View blog reactions

I recently had quite some trouble trying to install Microsoft SQL Server Management Studio on Windows Vista Ultimate. Note: I'm not referring to the Express edition which can be downloaded separately and installs like a charm. The root cause seems to be that once you've got SQL Server Express installed - maybe via Visual Studio 2005 or Visual Studio 2008 - the SQL Server 2005 installer thinks, there's nothing to be added to your install and quits.

Other solutions Google revealed pointed to either running SqlRun_Tools.msi or SqlRun_Tools.exe manually from the \Setup folder and did not work for me.

What did work was to opening a command prompt and running

setup SKUUPGRADE=1

where setup points to the 2 MB setup.exe file in SQL Server 2005's DVD root.

Hope this might help others, too.

 

 

comments
Nate stated:
# re: sql server management studio on windows vista
Thank you for sharing this. Worked great.
posted on 5/20/2008 9:01 PM
Me stated:
# re: sql server management studio on windows vista
i tried the trick

1. open command line
2. type "cmd" and press Ctrl+Shift+Enter
3. run the installation from dos (ex. type SQL.msi)

finally works!
posted on 6/17/2008 1:29 AM
Gil Bar stated:
# re: sql server management studio on windows vista
Works like a charm...
posted on 6/24/2008 9:28 AM
Jeff stated:
# re: sql server management studio on windows vista
Good find...thanks, I was stuck on this for a bit.
posted on 6/25/2008 7:10 PM
Vedha stated:
# re: sql server management studio on windows vista
Thank you for sharing this. Working great.
posted on 7/4/2008 10:50 AM
bgc stated:
# re: sql server management studio on windows vista
Were you installing from the Developer or Standard version? thanks
posted on 7/17/2008 5:23 PM
Arnold stated:
# re: sql server management studio on windows vista
Another thanks for sharing this. In my case I was installing the developer edition on a vista home premium platform that already had vs2005 installed and then vs2008 on top of that. Using the SKUUPGRADE trick caused setup to take a look and decide NOT to reinstall everything but the stuff that was missing; I was using the cd set and it jumped right onto the second cd and installed everything.
posted on 9/5/2008 1:01 AM
Paul stated:
# re: sql server management studio on windows vista
I have a vs 2005. I have a same problem to install
sql Management studio express edition. I need this software to host my web site done in local mode. Then I don't understand well your instruction. Would you explain a little more?
How can I open a command prompt? I spent a lot of time to solve this problem but it is uselss. Please advise me. Thanks in advance.....
posted on 11/4/2008 1:28 PM
post your comment
Title *
Name *
Email
Url
Comment *  
Please add 4 and 5 and type the answer here: