Get Just The Tools: SSMS Download

Posted by & filed under , .

toolEver jump on a machine to connect to a SQL Server and find out… whoops! No tools.  For some reason, the client machine doesn’t have SQL Server Management Studio (SSMS) installed.  Now I’m not talking about not having the SSMS installed on the server, but on the local workstation that you need to connect to the server with.

No tools has happened to me many times and, in fact, happened to me this past week.  In the past, this would mean running around trying to get find the client’s SQL Server installation media.  Maybe downloading a 4+ GB ISO of the entire SQL Server installation from TechNet.  Or, hopefully, making sure the client had USB ports open on their machines and that I had my installation media backup drive with me.  A lot of things that were more work than one would like.

With the release of SQL Server 2012 Service Pack 1, there is a new option on the table.  Instead of downloading everything, you can download just the management tools through the Microsoft® SQL Server® 2012 Service Pack 1 (SP1) Express download page.  Just select either SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe from the download options and you’ll have the full version of SSMS at your fingertips; in about a quarter the size of the full installation download.

  • Shadow Codex

    Yup this is probably the best thing since sliced cheese from microsoft.

  • Václav Mikeska

    Finally, I thought that Microsoft tries to keep it in secret

    • StrateSQL

      This is a great example of Microsoft listening to the community to make things better.

  • BWolfe

    Awesome, thanks!

  • Matthew

    Is there a way to get the tools but not with the Express limitations? I need to connect to our AS machines too.

    • StrateSQL

      Good question, I’ll see what I can find out.

  • Pingback: SQL Server 2012 Management Studio download | The Lonely DBA()

  • BananaMan!

    This is awesome. Thank you for the info!

  • pj

    That’s great!!! Thanks a lot!

  • Melissa Kirtz

    Does this include sqlcmd?

  • Rod

    Thank you! Ran into this problem a lot but decided to just work on the server since I could remote into it. I was becoming a pain in the butt as I needed to do more stuff in studio. Thanks a million for this!

  • Nij4t2

    Many thanks…

  • Pingback: Monday Morning SQL Break – May 11, 2015 | Strate SQL()

  • Pingback: Tuesday Morning SQL Break – May 26, 2015 | Strate SQL()

  • Pingback: Monday Morning SQL Break – June 1, 2015 | Strate SQL()

  • Brodie Yastrum

    Awesome post!

    Make sure you use INTERNET EXPLORER to download. I spent an hour trying to install via CHROME on WINDOWS 8 and couldn’t get it to work.