SQL Server Management Studio 21.0.1

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of SQL Server, Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VM, and Azure Synapse Analytics. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with many rich script editors to provide access to SQL Server for developers and database administrators of all skill levels.

Supported SQL offerings

• You can use it to manage all supported SQL Server versions, such as SQL Server 2022, SQL Server 2019, and earlier versions.
• SSMS 21 includes enhanced integration for managing Azure SQL Database and Azure SQL Managed Instance environments.

SSMS System Requirements

SQL Server Management Studio 21 is supported on the following 64-bit operating systems:

Supported Operating Systems:

• Windows 11 minimum supported OS version or higher: Home, Pro, Pro Education, Pro for Workstations, Enterprise, and Education
• Windows 10 minimum supported OS version or higher: Home, Professional, Education, and Enterprise.
• Windows Server 2022: Standard and Datacenter.
• Windows Server 2019: Standard and Datacenter.
• Windows Server 2016: Standard and Datacenter.

Package Specific

Major versions of SSMS install side by side. If you upgrade this package from an earlier major version (eg. 18.x, 19.x, 20.x), that version will remain installed.

As of version 21, SSMS now uses the standard Visual Studio installer to install and update SSMS.

Package Parameters

The default installation installs the SMSS core tools. You can use package parameters to install additional workloads:

• Microsoft.SqlServer.Workload.SSMS.AI
• Microsoft.SqlServer.Workload.SSMS.BI
• Microsoft.SqlServer.Workload.SSMS.HybridAndMigration
• Microsoft.SqlServer.Workload.SSMS.CodeTools

Example (install all workloads): choco install sql-server-management-studio --params "'--all'"

Package Updates

This package is automatically updated based on the same data source that SSMS itself uses to determine when updates are available. This may mean that there may sometimes be a delay between Microsoft releasing a new version and when they 'advertise' it as being generally available for SSMS to update.