Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .