Step by Step Installation of SQL Server Management Studio 18.6


By:   |   Updated: 2021-02-09   |   Comments   |   Related: 1 | 2 | 3 | 4 | 5 | 6 | More > Install and Uninstall


Problem

SQL Server Management Studio is software Microsoft developed for DBAs and developers to configure and manage SQL Server databases. In this tutorial series we created a VM, installed the OS and SQL Server. In this tutorial, now we will install SQL Server Management Studio to manage databases in this environment.

Solution

Microsoft has developed multiple IDE', tools and utilities to manage and configure SQL Server. SQL Server Management Studio is one of those IDE's that is very popular among SQL Server DBAs and developers. This tool was first launched with SQL Server 2005 and has since become more powerful in terms of managing SQL Server instances.

Initially, SSMS was part of SQL Server installation, but Microsoft has separated it from the SQL Server install and now the management tools need to be installed on its own.

You can use this link for downloading the latest SSMS version for a new SQL Server stand-alone installation.

This series has walked through the steps of setting up a new VM for Windows and SQL Server.  See the links below for more information.

Step by Step Process to Install Microsoft SQL Server Management Studio 18.6

1 - To download SSMS, go to this page on Microsoft.com as shown below to begin the installation process on the local computer.

sql server management studio

Scroll down to the section "Download SSMS" for the installation file as shown below and click on "Download SQL Server Management Studio (SSMS)".

download ssms

2 - The SSMS installer has been downloaded and stored in its desired location. You can see the downloaded file in the below screen.

local disk

Right click on the SSMS setup exe file and click "Run as administrator" to launch the SQL Server Management Studio installation wizard. You can see the same step in the screenshot below.

run as administrator

3 - You will see the installation center window below once you click on the run as administrator option for downloaded SSMS setup file. Here, you can select the correct location path where you want to install SSMS. I left it at its default location. Click "Install" as seen below to initiate the installation.

sql server management studio

4 - Once you click "Install", the SSMS installation will start. Initially it will load all packages and then it will start processing the installation. You can read about these stages on the installation progress bar. You can see that the packages are loading in the below image.

management studio

Once the package load is complete, the installation will be initiated by setup automatically. You don’t need to do anything there. You can see now that there are 2 progress bars showing in the below image. One is for package specific progress and the other is for the overall progress of this installation.

sql server management studio

Once all packages are processed, you will see the below screen where it says that installation has almost completed and setup is performing SSMS post install tasks.

ssms

SQL Server Management Studio has been installed successfully as shown in the image below. This installation requires a restart of the machine.

management studio

I clicked "Restart" to complete this installation. Once you restart the machine, you will see that updates are happening.  Don’t turn off your machine, let it run and complete the updates first.

working updates

Once the updates are applied, the system will come online post restart for users. You have successfully installed SQL Server Management Studio on your machine. You can go ahead and use it to access any version of SQL Server Instance available.

5 - The last step of this installation is validation of the SSMS installation. There are multiple ways to do this. You can go to the start menu and see newly installed programs. Here you can see that Microsoft SQL Server Tools 18 is showing as a newly installed program under which you can see Microsoft SQL Server Management Studio as seen in the image below.

windows server

The next option to validate this installation is to run the program and see that it is working. Select "SSMS" to launch it. You will see the below screen once you launch it. Let it run to load all programs. Once it is loaded, you will get a connection popup for authentication to the database engine and enter the credentials to connect to the server.

sql server management studio

You will see the below image. Enter the SQL Server instance details and hit "Connect" to establish the SQL Server database connection.

sql server

You can see that the database connection has been established with the SQL Server 2019 server name that we installed in our last article.

ssms
Next Steps

We have installed SQL Server Management Studio in this article. This tool is ready for use. Read more docs on SQL Server:






get scripts

next tip button



About the author
MSSQLTips author Manvendra Singh Manvendra Singh has over 5 years of experience with SQL Server and has focused on Database Mirroring, Replication, Log Shipping, etc.

View all my tips


Article Last Updated: 2021-02-09

Comments For This Article





download














get free sql tips
agree to terms