Download SQL Server Management Studio All Versions

BySubhan Zafar Hours

Microsoft SQL Server Management Studio (SSMS) is an all-in-one place for you to go if you want to…

SQL Server Management Studio All Versions

Microsoft SQL Server Management Studio (SSMS) is an all-in-one place for you to go if you want to manage your databases. SSMS gives you a graphical interface so you can manage your SQL databases from a local SQL server to an on-cloud database stack.

The SQL Server Management Studio can be used to deploy, monitor, and upgrade existing SQL databases. Some might even consider it an all-in-one solution.

Table of contents

This article gives you direct download links for all available SSMS versions that you can use to meet your requirements. But before we begin, let us give you a little insight into the versions released by Microsoft thus far.

SQL Server Management Studio System Requirements

Before you begin installing SSMS on your device, you’ll need to meet these minimum hardware requirements:

  • Processor: 1.8 GHz or faster x86 (Intel, AMD) processor
  • RAM: 2GB (2.5GB if running on a virtual machine)
  • Storage: Minimum of 2 GB (Can go up to 10 GB depending upon installed features)

Apart from the hardware requirements, you also need to ensure the right OS. The following operating systems are supported:

  • Windows Server 2022 (64-bit)
  • Windows 11 (64-bit)
  • Windows 10 (64-bit) version 1607 (10.0.14393) or later
  • 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)

SQL Server Management Studio Available Languages

SSMS can be downloaded and installed in the following languages:

  • English (US)
  • Chinese (Simplified)
  • Chinese (Traditional)
  • French
  • German
  • Italian
  • Japanese
  • Korean
  • Portuguese (Brazil)
  • Russian
  • Spanish

SQL Server Management Studio Download Links

Here’s the list of latest builds of SQL Server Management Studio:

VersionLatest versionReleaseDownload link
SQL Server Management Studio 1818.1 (Build 15.0.18390.0)2019Download
SQL Server Management Studio 1717.9.1 (Build 14.0.17289.0)2017Download
SQL Server Management Studio 1616.5.3 (Build 13.0.16106.4)2016Download
SQL Server Management Studio 142014 SP3 (Build 12.0.6024.0)2014Download
SQL Server Management Studio 122012 SP4 (Build 11.0.7001.0)2012Download
SQL Server Management Studio 2008 R22008 R2 SP2 (Build 10.50.4000.0)2010Download
SQL Server Management Studio 200820082008Download
SQL Server Management Studio 200520052005Download

You can also download a specific version if you don’t want the latest build:

VersionBuildDownload linkRelease date
18.1015.0.18390.0SQL Server Management Studio (SSMS) 18.10 5 Oct 2021
18.9.215.0.18386.0SQL Server Management Studio (SSMS) 18.9.215 Jul 2021
18.9.115.0.18384.0SQL Server Management Studio (SSMS) 18.9.120 Apr 2021
18.915.0.18382.0SQL Server Management Studio (SSMS) 18.915 Apr 2021
18.815.0.18369.0SQL Server Management Studio (SSMS) 18.817 Dec 2020
18.7.115.0.18358.0SQL Server Management Studio (SSMS) 18.7.127 Oct 2020
18.715.0.18357.0SQL Server Management Studio (SSMS) 18.720 Oct 2020
18.615.0.18338.0SQL Server Management Studio (SSMS) 18.622 Jul 2020
18.5.115.0.18333.0SQL Server Management Studio (SSMS) 18.5.19 Jun 2020
18.515.0.18330.0SQL Server Management Studio (SSMS) 18.57 Apr 2020
18.415.0.18206.0SQL Server Management Studio (SSMS) 18.44 Nov 2019
18.3.115.0.18183.0SQL Server Management Studio (SSMS) 18.3.12 Oct 2019
18.215.0.18142.0SQL Server Management Studio (SSMS) 18.225 Jul 2019
18.115.0.18131.0SQL Server Management Studio (SSMS) 18.111 Jun 2019
18.015.0.18118.0SQL Server Management Studio (SSMS) 18.024 Apr 2019
17.9.114.0.17289.0SQL Server Management Studio (SSMS) 17.9.121 Nov 2018
17.914.0.17285.0SQL Server Management Studio (SSMS) 17.94 Sep 2018
17.8.114.0.17277.0SQL Server Management Studio (SSMS) 17.8.126 Ju 2018
17.714.0.17254.0SQL Server Management Studio (SSMS) 17.79 May 2018
17.614.0.17230.0SQL Server Management Studio (SSMS) 17.620 Mar 2018
17.514.0.17224.0SQL Server Management Studio (SSMS) 17.515 Feb 2018
17.414.0.17213.0SQL Server Management Studio (SSMS) 17.47 Dec 2017
17.314.0.17199.0SQL Server Management Studio (SSMS) 17.39 Oct 2017
17.214.0.17177.0SQL Server Management Studio (SSMS) 17.27 Aug 2017
17.114.0.17119.0SQL Server Management Studio (SSMS) 17.127 Jun 2017
17.014.0.17099.0SQL Server Management Studio (SSMS) 17.025 Apr 2017
16.5.313.0.16106.4SQL Server Management Studio (SSMS) 16.5.330 Jan 2017
16.5.113.0.16100.1SQL Server Management Studio (SSMS) 16.5.15 Dec 2016
16.513.0.16000.28SQL Server Management Studio (SSMS) 16.526 Oct 2016
16.4.113.0.15900.1SQL Server Management Studio (SSMS) 16.4.123 Sep 2016
16.313.0.15700.28SQL Server Management Studio (SSMS) 16.320 Aug 2016
Summary of SSMS versions

There have also been preview releases for some of these versions that have not been mentioned in the table above.

To download any SSMS version in any other language, please visit Microsoft’s Release Notes page for direct download links.

How to Install SQL Server Management Studio

Once you have downloaded the SSMS, here is how to install it:

  1. Double-click the downloaded package to execute it.
  2. Click Install on the installation wizard.
    install 5
  3. SSMS will then begin installing on your PC. The process should take about 5 minutes, but can vary depending upon your system’s specifications. Once completed, click Close.
    close 2

You can now launch SSMS by searching for it through the Windows Search bar and begin using it just as easily.

SSMS
SQL Server Management Studio

Uninstall SQL Server Management Studio

If you ever want to uninstall the SSMS, here is how to do it:

  1. Launch the installation package you had previously downloaded by double-clicking it.
  2. Click Uninstall from the Wizard.
    uninstall 5
  3. The wizard will then remove SSMS from your device. Click Close when it is finished.
    close 2 1

FAQs

Is SQL Server the same as SSMS?

SQL Server Management Studio (SSMS) is a tool that allows you to create and manage SQL databases, whereas an SQL Server is a database designed to manage and store information. SSMS is included in Microsoft SQL Servers.

Can I use SSMS without SQL Server?

Yes, you can use SQL Server Management Studio without the server itself. This way you can manage and control on-premises SQL databases as well as on-cloud databases.

Also see:

Subscribe to our Newsletter

Get the latest tech news, advice and downloads in your inbox

Subhan Zafar is an established IT professional with interests in Windows and Server infrastructure testing and research, and is currently working with Itechtics as a research consultant. He has studied Electrical Engineering and is also certified by Huawei (HCNA & HCNP Routing and Switching).

Leave a Reply

You have to agree to the comment policy.