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.

2 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

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <pre> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>