Install SQL Server Management Studio 20 on Windows Server

Posted on Christian By Christian 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

Synology Cloud Sync How to Sync Data in Cloud Drives to Synology NAS Backup
Time machine How to Backup MacOS to Synology NAS via Time Machine Backup
Configure SQL Server to listen on a specific TCP port Configure SQL Server Instance to listen on a specific TCP Port Oracle/MSSQL/MySQL
oracle q4 earnings are in e28094 but what does it really mean 700x425 1 How to uninstall Oracle Database 11G or 12c Oracle/MSSQL/MySQL
image 10 How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer AWS/Azure/OpenShift
postgresql on windows Install PostgreSQL on Windows server as Veeam Database Engine Oracle/MSSQL/MySQL

Leave a Reply