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

sql-server database installation ssms
Jacek picture Jacek · Jun 30, 2012 · Viewed 495.7k times · Source

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

Usman picture Usman · Jul 1, 2012

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.

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but …

Read More