SQL Server 2012 Management Studio download

And finally it’s time to update my post on SSMS 2008 download with the new version, for everyone joy. Well actually we are on SQL2014 now, but as any brand-new Microsoft product, it will take some time until most of us are using it. The cost of updating existing servers is not exactly interesting – the newer versions will be used on mainly on new projects for a while.

And this brings me to the current post. Where do I download the 2012 version of just Management Studio? Actually this has been answered already, and in great detail, in this nice article by Jason Strate: http://www.jasonstrate.com/2013/05/get-just-the-tools-ssms-download/  (notice it’s from 2013).

The key here is to look for the Service Pack 1 product page of SQL 2012 Express. If you searching for the RTM version you will have less luck, as I pointed out on my first post about SSMS 2008r2 download. I strongly recommend the x64 version. But if you need the BIDS/SSIS pieces, you will need the full SQL installer and not these (as pointed out in my previous post).

Enough talk, go to the SQL 2012 SP1 Express page here: http://www.microsoft.com/en-us/download/details.aspx?id=35579, enter your language and look for the files named “SQLManagementStudio_x64_ENU.exe” or “SQLManagementStudio_x86_ENU.exe“.

As with my previous post, below are the direct links too (for english language – actually the only version you should consider):

SQL 2012 SSMS 64bits with SP1 direct link: http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLManagementStudio_x64_ENU.exe

SQL 2012 SSMS 32bits with SP1 direct link: http://download.microsoft.com/download/5/2/9/529FEF7B-2EFB-439E-A2D1-A1533227CD69/SQLManagementStudio_x86_ENU.exe

PS 1: while doing research for this post, I came across some great links about SQL lifecycle and support: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/2a9e52dc-4f21-41b1-8640-f0c2476c68d8/most-used-sql-server-version?forum=sqlsetupandupgrade

PS 2: stay away of SQL Express with Advanced Services, unless you really really want a database to run in your local workstation. This version is suited for developers who need a local DB – for remote server administration work you should only use the SSMS version without the local database engine.



About mauriciorpp

Hi, I am Piccolo - but not the one from Dragon Ball. I'm from a highly competitive and fast-paced world too, the IT industry, and this space will be used to share some challenges I face daily on my career. As you will see, I don't do brawls but I need to be a fighter! Stay tuned.
This entry was posted in SQLServer and tagged . Bookmark the permalink.

3 Responses to SQL Server 2012 Management Studio download

  1. bulolla says:

    Thanks for article. It really helped me.

  2. Ryan Reif says:

    This was very helpful. Thanks for sharing the research you completed!

  3. Pingback: SQL Server 2012 SP3 Management Studio Download | The Lonely DBA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.