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

SQL EvaluationExpired Windows could not start the SQL Server service on local computer 17051: A network-related or instance-specific error occurred while establishing a connection to SQL Server Oracle/MSSQL/MySQL
sql 1 Editions of MSSQL Server: What are the differences between various Editions of Microsoft SQL Server Oracle/MSSQL/MySQL
Fix invalid backup repostory and delete not needed repo via Veeam Backup Repository Fix missing path and delete a Veeam Backup Repository Backup
Screenshot 2020 06 23 at 10.52.52 How to uninstall Microsoft SQL Server on Windows Oracle/MSSQL/MySQL
Always on and Veeam plugin setup Install SQL Server Always On & Configure Veeam Plug‑in for SQL Backup
upgrade Microsoft SQL Server How to upgrade Microsoft SQL Server 2019 to 2022 Oracle/MSSQL/MySQL

Leave a Reply