How to install SQL Server Management Studio 2012 (SSMS) Express?

Question

I just installed SQL Server 2012 Express, I can connect with database from VS2012RC.

Database is working :) I use Win7 SP1 64bit.

I download program from page I choose ENU\x64\SQLManagementStudio_x64_ENU.exe

I want to install Management Studio 2012, but after unpack installer has stopped. I see only for moment some console application.

1. What could be cause?
2. Where can I find any log file?

Answer 1

You need to install ENU\x64\SQLEXPRWT_x64_ENU.exe which is Express with Tools (RTM release. SP1 release can be found here).

As the page states

Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express) This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above.

So install this and use the management studio included with it.

Answer 2

When I installed: ENU\x64\SQLManagementStudio_x64_ENU.exe

I had to choose the following options to get the management Tools:

1. "New SQL Server stand-alone installation or add features to an existing installation."
2. "Add features to an existing instance of SQL Server 2012"
3. Accept the license.
4. Check the box for "Management Tools - Basic".
5. Wait a long time as it installs.

When I was done I had an option "SQL Server Management Studio" within my Start Menu.

Searching for "Management" pulled it up faster within the Start Menu.