Point Deep

Mundeep's Tech Blog

Installing SQL Server 2005 Management Studio

Posted by mundeep on November 23, 2007

For some reason Microsoft decided to ‘hide’ the installation of the Management Studio in 2005. In Sql Server 2000 you simply choose to install the “Client Tools” only. For SQL Server 2005 to just install the Management Studio as a standalone you need to browse to the “Tools\Setup” folder underneath the SQL Server install folder (eg. in my case of an English 64-bit install “DVD-ROM:\ENGLISH\SQL2005\DEVELOPER\SQL Server x64\Tools\Setup”) and execute “SqlRun_Tools.msi”. The Mangmenet Studio is part of the Client Tools -> Management Tools.

About these ads

11 Responses to “Installing SQL Server 2005 Management Studio”

  1. geertdcod said

    How can I install SQL 2005/2008 management studio without any other client tools (VS, BOL, …), including all component required to perform connections.

    Thanks

  2. mundeep said

    geertdcod, simply follow the instructions i mentioned above and it should install the management studio for you without Visual Studio or BOL.

    If you have problems also see the following post on why the client tools sometimes don’t install:
    http://aspadvice.com/blogs/ssmith/archive/2007/09/24/Installing-SQL-2005-Management-Studio.aspx

  3. zohreh said

    Hi
    Thankyou so much and I hope you to be the most happy person in the world be cause you solved my problem:)

  4. Daniel said

    I found the SQLRun_Tool.msi file on the second CD of SQL Server 2005. However, I wasn’t able to install it it gave me this error message :-

    0:Watson 1:1807 2:StreamSupportFiles 3:getBootStrapDirectory 4:3
    5:t:\yukon\sql\setup\darwin\sqlcastub\catarget.cpp 6:100 7:sqlcastub.dll
    8:sqlrun.msi

    When clicked ok after that another message displayed :- “A valid destination folder for the install could not be determined”.

    I tried it on two different machine with the same error. Please help?

  5. Wayne said

    I spent all day today receiving the exact same message as Daniel above. I would love to know what it’s referring to — I could not find a “…\darwin\sqlcastub…” path anywhere. Anyone have any ideas?

  6. laputa said

    my company use sql server 2000,but i love sql server 2005/2008 management studio,how can i install it only?(without download the full sql server 2005)

  7. yetayeh said

    I WANT TO INSTALL SQL

  8. Mark said

    I ran into the same error, and it turned out to be UAC. I started a command prompt with “Run As Administrator” and then kicked off the tools installtion from that cmd prompt instance and they installed without any issues…

  9. Cesarrq said

    Just perfect!

  10. Beau said

    Thanks Mark!!

  11. Anonymous said

    I spent days tring to find how to install sql server management studio 2005, this is where I found the correct answer. Thank you!

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

 
Follow

Get every new post delivered to your Inbox.

%d bloggers like this: