How to install SQL Server Management Console in 2008 Express Version?

Question

I started a dozen attempts to install the SQL Server Management Studio for the 2008 Express Version of SQL Server.

What i use: Windows Vista 2007 SP 2

What i did: a) I downloaded the install file SQLManagementStudio_x86_DEU.exe from Microsofts Download Center

b) I started the setup, choosed "Installation"/"Adding Feature"

c) The feature selection appears, but i can chose only from SQL Client Connectivity SDK (see attachment) ![enter image description here][1]

d) This is wrong i guess; but even if i click next i get an error message like "Please chose a feature first"

What can i do?

Thanks for any advice!!!

Answer 1

For SQL 2008 R2: During the installation process, at the feature selection screen, you will have to select Shared Features > Management tools - Basic. This will install SSMS onto your system.

If you did not do this during the initial installation, you can rerun the setup process and only select Shared Features > Management tools - Basic. This will then install SSMS on your server.

Answer 2

Do any of these links help?

• http://connectsql.blogspot.com/2009/07/how-to-install-sql-server-management.html
• http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx
• http://msdn.microsoft.com/en-us/library/bb500441%28v=sql.100%29.aspx