Download & Install SQL Server Management Studio (SSMS)

This how-to guide explains how to download and install Microsoft SQL Server Management Studio or SSMS. The latest version of SSMS is now 18.2. You can use this connect to the SQL Server versions 2019, 2017, 2016, 2014, 2008 & 2008 R2

What is SQL Server Management Studio (SSMS)

SQL Server Management Studio (SSMS) is a GUI tool, which helps us to manage our SQL Server Installations. You can use this tool to design and manage the database and query its data. You can use this to manage the database, which is located in your PC or somewhere in the cloud.

Using SSMS 18.2, you can not only manage the SQL Server 2017, but the previous versions of the SQL Server starting from 2008. The list of supported versions is mentioned below.

Download SQL Server Management Studio

The latest version is available for download from the following link. The Current Version is 18.5

Direct Download links

EditionBuild/Version
No
Applicable to 
SQL Server Management Studio 18Version 18.5
Build No. 15.0.18330.0
SQL SERVER 2008, 2008R2 to 2019 Download

SQL Server Management Studio 17Version 17.9.1
Build No. 14.0.17289.0
SQL SERVER 2008, 2008R2 to 2019Download

SQL Server Management Studio 16Version 16.5.3
Build No. 13.0.16106.4
SQL SERVER 2008, 2008R2 to 2019Download

Official Download Page

Click the following page to go to Microsoft Official Download link.

Download SQL Server Management Studio 2017

System Requirements

The SSMS can be used to connect to the older versions of SQL Server. The following are supported. Also, scroll down to find the list of Supported OS

Supported SQL Server Editions

SQL Server EditionVersion No
SQL Server 200810.0
SQL Server 2008 R210.5
SQL Server 201211.0
SQL Server 201412.0
SQL Server 201613.0
SQL Server 201714.0
SQL Server 2019 Preview

Supported OS

  • Windows 10 (64-bit) *
  • Windows 8.1 (64-bit)
  • Windows Server 2019 (64-bit)
  • Windows Server 2016 (64-bit) *
  • Windows Server 2012 R2 (64-bit)
  • Windows Server 2012 (64-bit)
  • Windows Server 2008 R2 (64-bit)

Install SQL Server Management Studio

Download from the link given above and double click on the downloaded file to start the installation.

SQL Server Management Studio 2017 Setup file

Select Install Location

Say yes, when prompted for “Do you want to allow the following to make a change this computer? “. You will be taken to the Welcome screen.

You can change the installation location if you wish to. Click on the Install button to continue

Select Install Location

Installation Begins

Installation Starts

Installation in Progress

The installation will take time as it downloads the required packages from the internet.

Installation in Progress

Installation Complete

Installation completes. You may be asked to restart the PC.

SQL Server Management Studio Installation completes

References

Summary

In this tutorial, we learned how to install the SQL Server Management Studio. In the next article learn how to connect to the SQL Server using SSMS.

Leave a Comment

Your email address will not be published.

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

Scroll to Top