To continue utilizing Azure Active Directory authentication with MFA, you need SSMS 18.6 or later. In December 2021, releases of SSMS prior to 18.6 will no longer authenticate through Azure Active Directory with MFA. Installation of SSMS installs Azure Data Studio 1.28.0. Users of SQL Server Management Studio are now able to benefit from the innovations and features in Azure Data Studio.ĭownload – The version number for the latest release is 4.0Īzure Data Studio installation integration The latest version is labeled Microsoft SQL Server Management Studio 18.īeginning with SQL Server Management Studio (SSMS) 18.7, Azure Data Studio is automatically installed alongside SSMS. If a computer contains side-by-side installations of SSMS, verify you start the correct version for your specific needs. If you have a previous GA version of SSMS 18 installed, installing SSMS 18.9.1 upgrades it to 18.9.1. SSMS 18.x installs side by side with previous versions so both versions are available for use. The SSMS 18.x installation doesn’t upgrade or replace SSMS versions 17.x or earlier. SSMS combines a broad group of graphical tools with a number of rich script editors to provide developers and administrators of all skill levels access to SQL Server.
SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.
