In order to check whether SQL Server Management Studio (SSMS) has been installed successfully, you need to select start menu of your server and then further select the SQL Server 2012 menu. You will find the link to SQL Server Management Studio there.
To open SQL Server 2012 Management Studio Express click on the lower left hand side “Start” windows button then open folder Microsoft SQL Server 2012 then select SQL Server Management Studio. This will open up SQL Server 2012 Management Studio Express.
The location path is different for different versions of SQL Server, but is always within "C:\Program Files\Microsoft SQL Server\ \Tools\Binn\" or a similar subpath of "C:\Program Files(x86)".
To start SQL Server Management Studio On current versions of Windows, on the Start page, type SSMS, and then select Microsoft SQL Server Management Studio. When using older versions of Windows, on the Start menu, point to All Programs, point to Microsoft SQL Server, and then select SQL Server Management Studio.
Just download SQLEXPRWT_x64_ENU.exe from Microsoft Downloads - SQL Server® 2012 Express with SP1
You can get SSMS Express tools from here or full SQL Server Eval tools from here. MSDN/TechNet Downloads is currently the only place to get RTM versions (non-eval) of the SSMS 2012 toolset.
Note the first link now(dec 2017) points to 'Microsoft® SQL Server® 2012 Service Pack 2 (SP2) Express'. ssms 2014 and 2017 are still available.
I just ran into this problem. I had to open back the installation for SQL Server and click Installation -> New SQL server installation or add features to existing installation. Then when we follow the instruction until we reach feature selection, just check the SQL Management tools checkbox and continue.
I have no idea why this software is considered a feature and hidden like this. It should be a stand-alone software installation.
I've found that the command line is my friend in these situations.
I installed the SQL Server 2012 Enterprise Management Tools, including Management Studio, off the DVD (mounted ISO actually), without installing anything else using this command:
e:\setup.exe /Q /IACCEPTSQLSERVERLICENSETERMS /ACTION=install /FEATURES=Tools
Run the command prompt with elevated privileges. And be patient, as it has to unpack the installation files. Don't try to install the MSI files directly, as you lose the dependency checking packaged with the main installer.
Again, this is to install the full version off the Enterprise or Developer media, if you have it, and do not wish to settle for the free Express edition.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With