Easy-to-use graphical management tool for managing SQL Server

SQL Server Management Studio

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe

SQL Server Management Studio 20.0

  -  485 MB  -  Freeware

Sometimes latest versions of the software can cause issues when installed on older devices or devices running an older version of the operating system. Software makers usually fix these issues but it can take them some time. What you can do in the meantime is to download and install an older version of SQL Server Management Studio 20.0.


For those interested in downloading the most recent release of SQL Server Management Studio or reading our review, simply click here.


All old versions distributed on our website are completely virus-free and available for download at no cost.


We would love to hear from you

If you have any questions or ideas that you want to share with us - head over to our Contact page and let us know. We value your feedback!

  • SQL Server Management Studio 20.0 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    SQL Server Management Studio 20.0 Screenshot 1
  • SQL Server Management Studio 20.0 Screenshot 2
  • SQL Server Management Studio 20.0 Screenshot 3
  • SQL Server Management Studio 20.0 Screenshot 4
  • SQL Server Management Studio 20.0 Screenshot 5

What's new in this version:

- The 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.
- A 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
- Added icons to the Query Editor status bar to indicate the encryption method used for the connection
- Added Microsoft Entra ID authentication to New Login wizard
- Updated Microsoft.Data.SqlClient version to 5.1.4, which includes support for Strict encryption and Transport Layer Security (TLS) 1.3
- Updated Server Management Objects (SMO) version to 171.30.
- Updated DacFx version to 162.1.x
- Introduced 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)

Fixed:
- The New Column Master Key dialog supports Azure Key Vault using role permissions for authorization
- Resolved an issue with SSMS crashing when trying to connect to Azure Storage because the user didn't have access to any containers within the storage account
- Fixed an issue where users couldn't change their password with Trust server certificate enabled
- Improved handling for importing and deleting certificates
- Addressed issues related to text and images in the Link wizards
- Addressed vulnerability CVE-2023-2975 for the OpenSSL library

Join our mailing list

Stay up to date with latest software releases, news, software discounts, deals and more.

Subscribe