Install SQL Server Management Studio 20 on Windows Server

Posted on IT Expert By IT Expert No Comments on Install SQL Server Management Studio 20 on Windows Server
how to Install SQL Server Management Studio on Windows Server

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.

SQL Server Management Tools

Now, click on download SSMS 20.2 as shown below.

Download SSMS

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.

install SSMS

As you can see, the installation is in progress.

Installation in progress
SSMS installation progress

Now, we have successfully installed SSMS 20.2 onto our PC.

Finish install

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.

Launch SSMS

Once SSMS launches, connect to your SQL Server instance to start managing databases

Connect to server

You can confirm the version of SSMS installed also from the abut page as shown below.

SSSMS version

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.

5/5 - (1 vote)
Oracle/MSSQL/MySQL, Storage Tags:, , ,

Related Posts

More Related Articles

Change default postgreSQL database password How to change the default user password in PostgreSQL Oracle/MSSQL/MySQL
SQL server authentication mode Change from SQL Server and Windows Authentication Mode to Windows authentication Mode Oracle/MSSQL/MySQL
How to upgrade to SQL Server 2025 SQL Server 2025 Upgrade Requirements and Compatibility Oracle/MSSQL/MySQL
no pg hba Resolve “no pg_hba.conf entry for host on PostgreSQL Oracle/MSSQL/MySQL
Quick Connect How to fix Synology NAS Quick Connect is not enabled issue Storage
Distributed File System DFS How to find Dfs Referral Path and clear Dfs referral Cache Storage

Leave a Reply