Super User is a question and answer site for computer enthusiasts and power users. 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

While installing Visual Studio 2010, I saw an option to install SQL Express. I checked that option assuming it would install SQL Server Express as well, but apparently it didn't. When I type ssms.exe in Run, it says it cannot find it. Also, I do not see SQL Server Management Studio under Programs--> Microsoft SQL Server 2008. All I see is:

Import and Export Data (64 bit)
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Installation Center (64 bit)

When I click on SQL Server Installation Center (64 bit), it asks me to Browse for SQL Server 2008 Installation Media, but I am not sure where it is located at.

share|improve this question
up vote 1 down vote accepted

I'm pretty sure SQL Express doesn't include SSMS out of the box.

You can download Microsoft® SQL Server® 2008 Management Studio Express from Microsoft.

The error you're reporting does make it seem like it's not fully installed. You can get an installable stand-alone copy of MSSQL Express 2008 R2 from MS as well, which you could possibly use to repair or reinstall it.

share|improve this answer
This is it. When you download MSSQL, you need to select the options (w/Tools). – surfasb Jan 16 '12 at 0:32

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.