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.
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
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