How do I open SQL Server Management Studio?
I installed it but I don't see where I can open it.
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
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.
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.
You have to download this too... apparently, then the instructions given above will work. They are separate downloads.
On the taskbar, click Start, point to All Programs, point to Microsoft SQL Server SQL Server 2008, and then click SQL Server Management Studio.
Today, I installed SQL Server Management studio 18.3.1 on a managed environment, where the installer failed to create a shortcut.
I found it in:
"C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe"
Some time ago, I couldn't SQL Server Management Studio 17.x on a 32-bit OS, because it indicated that it required a 64-bit OS.
To my surprise, the program itself is 32-bit, verified by the 7-zip method, given in How to check if an EXE is 32-bit or 64-bit on Windows 10 and is installed in C:\Program Files (x86).