Launch PowerShell with elevated permissions. Unattended installįollow these steps to install SSMS in the background with no GUI prompts. To continue utilizing MFA, you need SSMS 18.6 or later.Ĭonnectivity to Azure Analysis Services through Microsoft Entra multifactor authentication requires SSMS 18.5.1 or later. In December 2021, releases of SSMS prior to 18.6 will no longer authenticate to Database Engines through Microsoft Entra multifactor authentication (MFA). The latest version is labeled Microsoft SQL Server Management Studio v20.1. If a computer contains side-by-side installations of SSMS, verify you start the correct version for your specific needs.

You can see if you have a preview version by going to the Help > About window. However, if you have an earlier preview version of SSMS 20 installed, you must uninstall it before installing the latest release of SSMS 20. SSMS 20.x installs alongside previous versions, so both versions are available. The SSMS 20.x installation doesn't upgrade or replace SSMS 19.x and earlier versions. If you have comments or suggestions or want to report issues, the best way to contact the SSMS team is at SQL user feedback. Installing SSMS 20.1 doesn't upgrade or replace SSMS 19.x and earlier versions.īy using SQL Server Management Studio, you agree to its license terms and privacy statement. If you have a preview version of SSMS 20 installed, uninstall it before installing SSMS 20.1. SSMS 20.1 is the latest generally available (GA) version. Download SSMSĭownload SQL Server Management Studio (SSMS) 20.1 Use SSMS to query, design, and manage your databases and data warehouses, wherever they are - on your local computer or in the cloud.įor customers needing a cross-platform companion to SSMS for managing SQL and other Azure databases, use Azure Data Studio.įor details and more information about what's new in this release, including important security changes, see Release notes for SQL Server Management Studio (SSMS) 20.1. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications and build queries and scripts.

SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

Adventureworks database download 2012