Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How do I open SQL Server Management Studio?

I installed it but I don't see where I can open it.

share|improve this question

migrated from stackoverflow.com Mar 1 '10 at 20:49

This question came from our site for professional and enthusiast programmers.

2  
Does Microsoft SQL Server Management Studio Express show up in the Control Panel under Add Remove Programs? –  heavyd Mar 1 '10 at 21:04

10 Answers 10

up vote 19 down vote accepted

Click on the Windows Start button, click on the "Run" option and try to run the following command:

ssms.exe

Works for me, your mileage may vary (as they say).

share|improve this answer
    
it helped me as i am using windows 8 and there is no start button but run command there –  Devjosh Nov 7 '12 at 15:48

Unless things have changed since I tried this, then, if you downloaded the file described as 'Microsoft® SQL Server® 2008 Management Studio Express' and installed it without carefully reading the screen prompts, then you may not have actually installed the Management Studio.

The reason is that the installation file is (despite the name) not just the Management Studio, but actually the Sql Server express plus the management tools, so it is possible you might have installed the sql server and not the management tools.

To add the Management Studio to your existing installation, you re-run the installation program and then first select 'New SQL Server stand-alone installation or add features to an existing Sql Server 2008 instance'.

After several screens, you get to a choice to either 'Perform a new installation of Sql Server 2008' or to 'Add features to an existing instance of Sql Server 2008'

You might naturally think that the second option was the correct one, but this did not work for me and others on the internet, one of whom had discovered that the trick is to pretend you want to install a new installation of Sql Server 2008 which then later gives you the option to select what you want to install and you need to select 'Management Tools - Basic'

Not exactly straightforward and appears to have caught several people out.

share|improve this answer
    
it works for me. thanks –  Mahes Aug 6 '12 at 0:53

Mine is under Start -> Programs -> SQL Server 2005 -> SQL Server Management Studio

share|improve this answer
    
mine is 2008 i dont see it there! –  every_answer_gets_a_point Mar 1 '10 at 20:22

On my XP machine the shortcut points to:
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe

share|improve this answer
1  
I could kiss you for this answer, and I wouldn't normally do that very easily. –  ProfK Jan 29 '12 at 7:36

As you said you can't find the shortcut, are you 100% you installed it?

SQL Server Management Studio (express) is typically installed separately to SQL Server.

Here is a link for the 2008 version.

share|improve this answer
    
Yea, I can only think if you can't see it under Start->Programs->Microsoft SQL Server 2008 then it didn't install properly. –  BBlake Mar 30 '10 at 12:21

You have to download this too... apparently, then the instructions given above will work. They are separate downloads.

http://www.microsoft.com/en-us/download/details.aspx?id=7593

share|improve this answer

From Introducing SQL Server Management Studio

On the taskbar, click Start, point to All Programs, point to Microsoft SQL Server SQL Server 2008, and then click SQL Server Management Studio.

share|improve this answer
    
its not there i dont see it –  every_answer_gets_a_point Mar 1 '10 at 20:25

Use search, find Ssms.exe. If you found it, scan it for virus first (who knows what those sly virus makers name their stuff), then if no virus found, start it. If the file is not found, re-install the program.

share|improve this answer

For SQL Server 2005, click Start -> Run then type sqlwb

This will open SQL Server Management Studio

share|improve this answer

For SQL Management Studio 2014 you can find smss.exe in

C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio
share|improve this answer

protected by Community Oct 8 at 13:39

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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