SQL Server Management Studio (SSMS) is a powerful tool for managing SQL infrastructure, from SQL Server to Azure SQL Database. In this guide, we shall discuss how to Install SQL Server Management Studio 20 on Windows Server. Please, see how to Upgrade VBR to 12.3.1: Setup detected inconsistent configuration, how to deploy and integrate VHR with VBR, and how to perform In-place upgrade of Windows Server 2022 to 2025.
SSMS lets you configure, monitor, and administer database instances efficiently. With SSMS, you can deploy, monitor, and upgrade data-tier components, as well as build and execute queries and scripts to optimize your applications.
Also, see how to Please, see how to Upgrade VBR to 12.3.1: Setup detected inconsistent configuration, how to perform In-place upgrade of Windows Server 2022 to 2025, and how to encrypt Microsoft SQL Server Traffic.
Install SQL Server Management Tool
SSMS 20.2 is the latest GA version. Before installing it, uninstall any preview version of SSMS 20. This installation does not upgrade or replace SSMS 19.x or earlier versions. Instead, it runs alongside them, allowing multiple versions to coexist.
You can launch the SQL Server Installation center to download the SSMS. This will redirect you to the following URL to download the latest version of this tool.
Now, click on download SSMS 20.2 as shown below.
Also, see How to install Microsoft SQL Server Management Studio, how to perform vulnerability scan on Microsoft SQL Server, and how to Install MSSQL 2019 Developer Edition and SSMS on Windows.
Install SSMS
To install SSMS, double-click on the downloaded setup file as shown below and click on Install.
As you can see, the installation is in progress.
Now, we have successfully installed SSMS 20.2 onto our PC.
Note: SSMS installs Azure Data Studio by default for versions 18.7 through 19.3. SSMS does not install Azure Data Studio with SSMS 20.0 and higher.
Here is How to uninstall Microsoft SQL Server Management Studio, and how to manually check and update SQL Server Management Studio.
Launch SQL Server Management Studio
To do this, search for SQL Server Management Studio 20 from the Startup Menu and click on it.
Once SSMS launches, connect to your SQL Server instance to start managing databases
You can confirm the version of SSMS installed also from the abut page as shown below.
I hope you found this article on how to “Install SQL Server Management Studio 20 on Windows Server” very useful. Please, feel free to leave a comment below.
