Get Just The Tools: SSMS Download

by Jason S, posted in SQL Server, SQLServerSyndication

Updated June, 2016

Ever 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.

As SQL Server 2016 was developed, Microsoft made an exciting change in which SQL Server Management Studio would now be a available on the web without the need to download everything else.  While this download is specific to SQL Server 2016, it does work with previous versions of SQL Server.  I recommend this version for any modern version of SQL Server.

Download SQL Server Management Studio from Microsoft here.

For other versions of SQL Server, you can get downloads from these locations:

For either of these, select either SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe from the download, depending on the need for you environment.

26 thoughts on “Get Just The Tools: SSMS Download”

  1. Pingback: SSMS 2016 individual download | The SQL DBA
  2. Pingback: Monday Morning SQL Break – May 23, 2016 | Strate SQL
  3. Pingback: Monday Morning SQL Break – February 22, 2016 - SQL Server - SQL Server - Toad World
  5. Pingback: Monday Morning SQL Break – January 25, 2016 | Strate SQL
  6. Pingback: Monday Morning SQL Break – January 18, 2016 - SQL Server - SQL Server - Toad World
  7. Pingback: Monday Morning SQL Break – December 28, 2015 - SQL Server - SQL Server - Toad World
  8. Pingback: Monday Morning SQL Break – December 21, 2015 - SQL Server - SQL Server - Toad World
  9. Pingback: Monday Morning SQL Break – November 9, 2015 | Strate SQL
  10. Pingback: Monday Morning SQL Break – July 27, 2015 | Strate SQL

  11. 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.

    Like

  12. Pingback: Monday Morning SQL Break – June 1, 2015 | Strate SQL
  13. Pingback: Tuesday Morning SQL Break – May 26, 2015 | Strate SQL
  14. Pingback: Monday Morning SQL Break – May 11, 2015 | Strate SQL

  16. 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!

    Like

  20. Pingback: SQL Server 2012 Management Studio download | The Lonely DBA

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

    Like

Comments are closed.