How To Install Microsoft SQL Server Management Studio (SSMS)?

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 query, design, and manage your databases and data warehouses, wherever they are – on your local computer, or in the cloud.

In this article, will see how to install Microsoft SQL Server Management Studio (SSMS) on your PC.

Follow the below steps for the same.

Step 1

Click here to navigate to SQL Server Downloads web page.

Step 2

Click on Download SQL Server Management Studio (SSMS).

How to install Microsoft SQL Server Management Studio (SSMS)?

Step 3

You can see the latest version of the SSMS here.

Under the Download SSMS section, Click on Free Download for SQL Server Management Studio (SSMS) 18.10 to download the executable file.

Note: SSMS version will be changed based on the new releases by Microsoft. Download the latest SSMS as shown in the Download SSMS section.

How to install Microsoft SQL Server Management Studio (SSMS)?

SSMS-Setup-ENU.exe will be downloaded to your PC.

Step 4

Double click on SSMS-Setup-ENU.exe executable file to start the SSMS installation.

How to install Microsoft SQL Server Management Studio (SSMS)?

Step 5

Click on Change, if you wish to change the location of the SQL Server.

Otherwise, go to Next Step.

How to install Microsoft SQL Server Management Studio (SSMS)?

Step 6

Click on Install.

How to install Microsoft SQL Server Management Studio (SSMS)?

Installation steps are in progress.

How to install Microsoft SQL Server Management Studio (SSMS)?

How to install Microsoft SQL Server Management Studio (SSMS)?

How to install Microsoft SQL Server Management Studio (SSMS)?

SSMS Installation completed successfully.

How to install Microsoft SQL Server Management Studio (SSMS)?

Step 7

Click on Microsoft button and Search for SSMS. Click on Open.

How to install Microsoft SQL Server Management Studio (SSMS)?

Microsoft SQL Server Management Studio will be launched on your PC.

How to install Microsoft SQL Server Management Studio (SSMS)?

Step 8

Provide all the required details and Click on Connect to open your required Database.

How to install Microsoft SQL Server Management Studio (SSMS)?

Hope you have successfully Downloaded, Installed and Connected to your database in SSMS on your PC.

Please like and share your valuable feedback on this article.