Download SQL Server Management Studio (SSMS) All Versions [2023]

SQL Server Management Studio All VersionsSQL 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.

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 different requirements and prerequisites.

What is SQL Server Management Studio

As mentioned above, SQL Server Management Studio, or SSMS, is an integrated management environment for a SQL Server architecture. It offers a user interface, a set of tools, and sophisticated script editors that communicate with SQL Server.

The user-friendly interface and convenient manageability of the SSMS make it easier for the developers to manage the many SQL databases, perform maintenance works, and access them when required.

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 that you have the right operating system. The following operating systems are currently supported:

Download all versions of Windows Server.

SQL Server Management Studio Download Links

Here’s the list of the latest builds of SQL Server Management Studio. Click the Download button to immediately begin downloading the tool.

VersionLatest versionReleaseDownload link
SQL Server Management Studio 1919.0.1 (Build 19.0.20200.0)2023Download
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 of SSMS:

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. Download the setup file for the SSMS version from the given links above.

  2. Run the downloaded file.

    The installation wizard will then run.

  3. Click Install.

    install 5
    Begin SQL Server Management Studio installation

    SSMS will now begin installing on your PC. The process should take about 5 minutes but can vary depending on your system’s specifications.

  4. Once installed, click Close.

    close 2
    Close the installation wizard

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

SSMS
SQL Server Management Studio

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

Uninstall SQL Server Management Studio

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

  1. Run the downloaded setup file for SSMS previously used for installation.

    If you don’t already have it, you can download the setup file from the direct download links shared above.

  2. Click Uninstall from the wizard.

    uninstall 5
    Uninstall SSMS

    The wizard will then remove SSMS from your device.

  3. Click Close when it is finished.

    close 2 1
    Close the uninstallation wizard

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.

If you liked this post, Share it on:
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).

2 comments

  • Brahim HDIH
    Brahim HDIH

    Hi,
    When finishing installing MSSMS 18.3, I can not access with windows authentication. Would you help me please?

    • Usman Khurshid
      A
      Usman Khurshid

      The default login full name for the User is [BUILTIN\Users]. Use this user tfor Windows Authentication and the databases should work properly.

Get Updates in Your Inbox

Sign up for the regular updates and be the first to know about the latest tech information

Talk to us now

Talk to us straight and get your questions answered right away

Tell Us About Your Project