How To Install SQL Server Management Studio 2019

In this post, learn how to download and install SQL Server Management Studio 2019 step-by-step. The latest version of SQL Server Management Studio (SSMS) is 18.9.2 released on July 15, 2021.

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. Use SSMS to deploy, monitor, and upgrade the data-tier components used by your applications, and build queries and scripts. Use SSMS to manage, query, design your databases and data warehouses, wherever they are – in the cloud, or on your local computer.

 Note
Azure Data Studio is automatically installed alongside SQL Server Management Studio (SSMS) in the latest version 18.8. Azure Data studio is a cross-platform and open-source desktop tool for your environments, whether in the cloud, on-premises, or hybrid.

How To Install Microsoft SQL Server Management Studio in Windows 11 and Windows 10/8/7

 Step 1. Visit this source to download SQL Server Management Studio 2019. Click the “Download” button.

Step 2. Once the download is completed, find the .exe file. Double-click the SSMS-Setup-ENU.exe file to starting installing.

Select “Yes” on any security prompt.

Step 3. After giving permission to install, the installation window pops up. Click the “Install” button.

Step 4. After loading packages progress bar will be shown. One is Package Progress and Overall Progress. Wait for few minutes while the installer sets up the software.

Step 5. After completing the installation restart your computer.

Step 6. Navigate to all programs in your systems, you can see two folders one is Microsoft SQL Server Tool 2018 and another one is Microsoft SQL Server 2019. Under Microsoft SQL Server Tools 18, locate the Microsoft SQL Server Management Studio 18 and double click on it. The first time running it will take a few minutes.

Now you can connect to the server and use SQL Server Management Studio 2019.

In this video, we are gonna show you how to install SQL Server Management Studio 2019 step-by-step:

Hope something helps you.

Loading Facebook Comments ...