Using rss feeds with ssis

Downloading SQL Server Management Studio (SSMS)

Scope of application:SQL Server (all supported versions) Azure SQL database Azure SQL managed instance Azure Synapse Analytics

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools for configuring, monitoring, and managing instances of SQL Server and databases. Use SSMS to build queries, script, deploy, monitor, and update the data-tier components used by your applications.

Use SSMS to query, design, and manage your databases and data warehouses, whether they are on your local computer or in the cloud.

Download from SSMS

Downloading SQL Server Management Studio (SSMS) 18.9.1

SSMS 18.9.1 is the latest generally available version. If you installed an earlier generally available version of SSMS 18, installing SSMS 18.9.1 will upgrade it to version 18.9.1.

  • Release number: 18.9.1
  • Build number: 15.0.18384.0
  • Release date: April 20, 2021

If you have any comments, suggestions, or want to report problems, the best way to reach the SSMS team is through the SQL Server User Feedback. By using SQL Server Management Studio, you agree to the license terms and privacy policy.

Installing SSMS 18.x does not upgrade or replace SSMS version 17.x or earlier versions. SSMS 18.x is installed in parallel with earlier versions so that both versions are available. However, if a Preview version is installed by SSMS 18.x, you must uninstall it before installing SSMS 18.9.1. You can check that you have the Preview version by going to the Help window and then to About.

If a computer has parallel installations of SSMS, make sure you are starting the correct version for your specific needs. The latest version is called Microsoft SQL Server Management Studio 18.

Important

Starting with SQL Server Management Studio 18.7 (SSMS), Azure Data Studio is automatically installed with SSMS. SQL Server Management Studio users can now take advantage of what's new and features in Azure Data Studio. Azure Data Studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises or in a hybrid environment.

For more information about Azure Data Studio, see What is Azure Data Studio? or in the Frequently Asked Questions.

Available languages

This version of SSMS can be installed in the following languages:

SQL Server Management Studio 18.9.1:
Chinese (simplified) | Chinese (traditional) | English (United States) | French | German | Italian | Japanese | Korean | Portuguese (Brazil) | Russian | Spanish

tip

To access this page from a non-English language version and see the latest content, visit the US English version of the website. You can download different languages ​​from the US English website by selecting available languages.

Note

The SQL Server PowerShell module is a separate installation via the PowerShell catalog. For more information, see Download SQL Server PowerShell Module.

New

For more information and details about what's new in this release, see the SQL Server Management Studio (SSMS) Release Notes.

There are a few known issues for this release.

Previous versions

This article applies to the latest version of SSMS only. Visit Previous Versions of SSMS if you want to download the previous versions of SSMS.

Note

In December 2021, releases of SSMS prior to version 18.6 will no longer be authenticated through Azure Active Directory with MFA.

If you want to continue using Azure Active Directory authentication with MFA, you need SSMS 18.6 or higher.

Unattended installation

You can also install SSMS using a command prompt script.

If you want to install SSMS silently without GUI prompts, follow the steps below.

  1. Start the command prompt with elevated privileges.

  2. Enter the following command at the command prompt.

    Example:

    You can also / Passive instead of / Quiet passed to see the setup user interface.

  3. If everything works, you will see in this example that SSMS will be installed under “% systemdrive% \ SSMSto \ Common7 \ IDE \ Ssms.exe”. If an error has occurred, you can view the error code issued and the log file under% TEMP% \ SSMSSetup.

Installation with Azure Data Studio

  • Starting with SSMS 18.7, SSMS installs a system version of Azure Data Studio by default. If the workstation already has a system version of Azure Data Studio that is at least the same as the version of Azure Data Studio it contains (stable or Insider), the installation of Azure Data Studio will be skipped by SSMS. For the Azure Data Studio version, see the release notes.
  • The installer for the Azure Data Studio system requires the same security rights as the SSMS installer.
  • The Azure Data Studio installation was completed using the standard Azure Data Studio installation options. These are used to create a start menu folder and to add Azure Data Studio to the path. A desktop shortcut is not created and Azure Data Studio is not registered as the default editor for any file type.
  • Azure Data Studio is localized with language pack extensions. To localize Azure Data Studio, download the appropriate language pack from the Marketplace extension.
  • At this point, the Azure Data Studio installation can be skipped by launching the SSMS installer with the command line flag.

Uninstall

There are shared components that remain installed after you uninstall SSMS.

The shared components that remain installed are as follows:

  • Azure Data Studio
  • Microsoft .NET Framework 4.7.2
  • Microsoft OLE DB driver for SQL Server
  • Microsoft ODBC Driver 17 for SQL Server
  • Microsoft Visual C ++ 2013 Redistributable Components (x86)
  • Microsoft Visual C ++ 2017 Redistributable Components (x86)
  • Microsoft Visual C ++ 2017 Redistributable Components (x64)
  • Microsoft Visual Studio Tools for Applications 2017

These components are not uninstalled because they can be shared with other products. If they are uninstalled, there is a risk that other products will be deactivated.

Supported SQL Offerings

  • This version of SSMS works with all supported versions of SQL Server 2008 - SQL Server 2019 (15.x) and provides the highest level of support available for working with the latest cloud capabilities in Azure SQL Database and Azure Synapse Analytics.
  • In addition, SSMS 18.x can be installed in parallel with SSMS 17.x, SSMS 16.x or SQL Server 2014 SSMS and earlier versions.
  • SQL Server Integration Services (SSIS): SSMS version 17.x or later does not support connecting to the legacy SQL Server Integration Services. Use the version of SSMS that aligns with the version of SQL Server to connect to an earlier version of Integration Services. For example, use SSMS 16.x to connect to the legacy service SQL Server 2016 Integration Services. SSMS 17.x and SSMS 16.x can be installed in parallel on the same computer. Starting with the SQL Server 2012 release, it is recommended that Integration Services packages be stored, managed, run, and monitored using the SSIS Catalog Database (SSISDB). For more information, see the SSIS Catalog.

SSMS system requirements

The current release of SSMS supports the following 64-bit platforms when used with the current service pack:

Supported Operating Systems:

  • Windows 10 (64-bit) version 1607 (10.0.14393) or higher
  • 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)

Supported hardware:

  • x86 processor with 1.8 GHz or faster (Intel, AMD). Dual core or better recommended
  • 2 GB RAM; 4 GB RAM recommended (2.5 GB minimum if running on a VM)
  • Hard Disk Space: At least 2 GB up to 10 GB of available space

Note

SSMS is only available as a 32-bit application for Windows. If you need a tool that will run on operating systems other than Windows, Azure Data Studio is recommended. Azure Data Studio is a cross-platform tool that runs on macOS, Linux, and Windows. For more information, see Azure Data Studio.

Getting help with SQL tools

Next Steps

Contribute to the SQL documentation

Did you know that you could edit the content yourself? Not only does this make our documentation better, but it also lists you as a contributor to the side.