Security advisories 20.2.1$$$FeaturetDetails$$$CVE-2025-29803tThis security update addresses an Elevation of Privilege vulnerability in the Visual Studio Tools for Applications 2022 Installer.

Whats new in 20.2$$$FeaturetDetails$$$Always EncryptedtIntroduced support for temporal tables.$$$Always EncryptedtIntroduced logging for the Always Encrypted wizard to facilitate troubleshooting.$$$DriverstUpdated SSMS to use the latest driver version for MSOLEDBSQL (18.7.4). The inclusion of this new version could require users who also have older versions of the driver to reboot after installing SSMS 20.2. For more information; review the release notes for the Microsoft OLE DB driver.$$$Integration ServicestRemoved HADOOP files from SQL Server Integration Services (SSIS) installation files; this addresses CVE-2022-25168.$$$LibrariestUpdated DacFx to version 162.3.566.$$$LibrariestUpdated Server Management Objects (SMO) to version 171.36.0.$$$LibrariestRemoved the Microsoft Visual C++ 2013 Redistributable (x86) from the SSMS installation. Upgrading from a previous version of 20.x does not remove the files.$$$Link feature for Azure SQL Managed Instance

Refer-https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#201

Refer - https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#whats-new-in-193$$$$$$Whats new in 20.0$$$FeaturetDetails$$$ConnectiontThe connection security properties Encryption and Trust server certificate now exist on the main sign in page in the Connection dialog for easier access. For more information; see Connect with SQL Server Management Studio.$$$ConnectiontA new property; Host Name in Certificate; used with the Strict (SQL Server 2022 and Azure SQL) and Mandatory Encryption options; now exists on the Login page of the Connection dialog.$$$ConnectiontAdded icons to the Query Editor status bar to indicate the encryption method used for the connection.$$$ConnectiontAdded Microsoft Entra ID authentication to New Login wizard.$$$DriverstUpdated Microsoft.Data.SqlClient version to 5.1.4; which includes support for Strict encryption and Transport Layer Security (TLS) 1.3.$$$LibrariestUpdated Server Management Objects (SMO) version to 171.30.0$$$LibrariestUpdated DacFx version to 162.1.x.$$$OptionstIntroduced a new option; Trust server certificate for imported connections; in Tools > Options > SQL Server Object Explorer > Commands under Connection security. For more information; see Options (SQL Server Object Explorer - Commands).$$$Bug fixes in 20.0$$$FeaturetDetails$$$Always EncryptedtThe New Column Master Key dialog supports Azure Key Vault using role permissions for authorization.$$$ConnectiontResolved an issue with SSMS crashing when trying to connect to Azure Storage because the user didnt have access to any containers within the storage account.$$$ConnectiontFixed an issue where users couldnt change their password with Trust server certificate enabled.$$$Link feature for Azure SQL Managed InstancetImproved handling for importing and deleting certificates.$$$Link feature for Azure SQL Managed InstancetAddressed issues related to text and images in the Link wizards.$$$SecuritytAddressed vulnerability CVE-2023-2975 for the OpenSSL library.$$$Known issues 20.0$$$FeaturetDetailstWorkaround$$$Analysis ServicestWhen you connect to Analysis Services with Microsoft Entra MFA; if you add a new role or open properties for a role; the message the identity of the user being added to the role isnt fetched properly appears.tThis error is benign and can be ignored. The error is addressed within the Azure infrastructure; and no updates to SSMS are required.$$$Analysis ServicestAfter adding a new role; or when opening properties for an existing role; you cant use Search by name or email address to add a user.tA user can be added with the Manual Entry option.$$$Database DesignertSelecting the Design option for a view referencing a table using spatial data causes SSMS to crash.tUse T-SQL to make changes to the view.$$$Database MirroringtIf you launch the Database Mirroring Monitor from the mirrored node; the primary node isnt listed.tRegister the mirrored node from Database Mirroring Monitoring; or use SSMS 18.12.1 to monitor from the mirrored node.$$$General SSMStImport settings from SSMS 17 option not available.tSettings can be imported from SSMS 18.$$$Link feature for Azure SQL Managed InstancetAfter you remove an existing mirroring endpoint certificate on SQL Server; link creation through the wizard might fail due to unestablished trust between SQL Server and Azure SQL Managed Instance; even though all checks are successful.tUse PowerShell command Get-AzSqlInstanceServerTrustCertificate to check whether SQL Server mirroring endpoint certificate named <SQL_Server_Instance_Name> exists in the Azure SQL Managed Instance. If so; use PowerShell command Remove-AzSqlInstanceServerTrustCertificate to remove it before a new link creation attempt.$$$Linked serverstCreating a linked server to Azure SQL Database with SQL Server selected as Server type connects to the master database.tTo create a linked server to Azure SQL Database; select Other data source for the Server type; and select Microsoft OLE

Refer - https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#whats-new-in-193

Refer - https://learn.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver16#whats-new-in-192

Whats new in 19.1$$$New ItemtDetails$$$Azure Data Studio installation integrationtThe installation of SSMS installs Azure Data Studio 1.44.$$$Always EncryptedtAdded support for secure enclaves and in-place encryption in the Always Encrypted Wizard. See Configure column encryption using Always Encrypted Wizard.$$$Azure SQL Managed InstancetIntroduced visibility to the status of the Distributed Transaction Coordinator (DTC) service for Azure SQL Managed Instance. Object Explorer can be used to determine if DTC is enabled on the Azure SQL Managed Instance (within the Management node). See Distributed Transaction Coordinator (DTC) for Azure SQL Managed Instance.$$$Backup/RestoretAdded capability to restore backup files from Amazon S3 storage to SQL Server 2022 and Azure SQL Managed Instance.$$$General SSMStUpdated File Version for ssms to align with product version.$$$General SSMStRemoved deprecated hardware from the list of available service-level objects.$$$General SSMStChanged the system browser setting; within Tools > Options > Azure Services; to default to True. The external browser will be used; instead of the legacy embedded browser.$$$General SSMStRemoved Vulnerability Assessment from SSMS.$$$Link feature for Azure SQL Managed InstancetAdded Network Checker wizard; providing the capability to test the network connection and ports prior to creating the link.$$$Link feature for Azure SQL Managed InstancetAdded an advanced network troubleshooting capability within the existing link creation wizard. This provides the capability to troubleshoot network connectivity issues while link creation is in progress.$$$Object ExplorertRemoved script header text when selecting the top 1000 rows. See Remove the /****** Script for SelectTopNRows command from SSMS ******/ comment when Select Top 1000 Rows.$$$PowerShelltAdded ability for users to choose the version of PowerShell to use when launched from SSMS.$$$PowerShelltIntroduced more PowerShell options within Tools > Options > SQL Server Object Explorer > Commands. For more information; visit Options (SQL Server Object Explorer - Commands).$$$Bug fixes in 19.1$$$New ItemtDetails$$$AccessibilitytIntroduced multiple screen reader improvements in the installation window and on the main page.$$$Attach DatabasetAddressed issue where attaching a database with a log file that did not reside in the default directory displayed the message Transaction log file not found. A new empty log will be created.$$$Azure SQL Managed InstancetFixed controls that were incorrectly disabled in New Linked Servers wizard and prevented customers from creating a linked server using the MSOLEDBSQL driver.$$$Azure SQL Managed InstancetAddressed inability to configure Integration Services tasks in a SQL Server Agent Job in Azure SQL Managed Instance. See Configuration of SSIS Task for Agent Job in SSMS 19.0.1 Does Not Work in Azure SQL Managed Instance.$$$Backup/RestoretUpdated database backup dialog to enable OK button when connect to an Availability Group via the Listener or IP address.$$$ConnectiontFixed an issue where an expired Active Azure Directory refresh token cause SSMS to crash.$$$ConnectiontAddressed intermittent application crash when closing SSMS immediately after connection dialog closes.$$$ConnectiontUpdated authentication process for an alias-based email to allow the authentication token for subsequent connections for the same login.$$$Data ClassificationtResolved freeze in SSMS that occurred when trying to set Microsoft Information Protection Policy.$$$Full Text IndexingtFixed issue that did not permit viewing the properties of a full text index.$$$GeneraltDelayed the initialization of the output window to prevent slow SSMS startup.$$$IntellisensetAdded support for SORT_IN_TEMPDB T-SQL syntax when creating a primary key using ALTER TABLE.$$$IntellisensetUpdated Intellisense to identify invalid index operations for ALTER TABLE T-SQL syntax.$$$IntellisensetIntroduced support for SQL