Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have Microsoft SQL Server 2008 Express Edition already installed, and now I want to install SQL Server 2008 Management Studio Express.

I've tried with the only two options that look feasible:

  • [...] Add features to an existing installation
  • Launch a wizard to change your edition of SQL Server 2008 [...]

But in the Features Selection step, Management Studio never appears as an option.

What can I do?

share|improve this question
up vote 4 down vote accepted

I haven't looked further into this but can confirm this is what happens - perhaps due to the service pack levels differing? (installed instance being SP1 and the tool installer not)

I just used control panel and changed the installed SQL 2008 to remove the database service instance.

Then I installed the MSSQL 2008 Express edition that includes the standard tools - and the option for management studio was there to check... not an elegant solution but it worked - so I didn't bother to figure out the original problem.

share|improve this answer
Looks like that's the only way to go. I didn't wanted to download it all over again... How comes MS doesn't have such awesome tools as Aptitude in Linux... – Jose Carlos Aug 22 '09 at 22:08
Oh no, are we trying to insite a relious war again? – Mark Henderson Aug 23 '09 at 1:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.