Install SQL Server Management Studio

In this article, we will show you the step by step procedure to install SQL Server Management Studio with screenshots. SQL Management Studio is instrumental if your system has SQL Server instance, and you want to control the data from SSMS.

Install SQL Server Management Studio – First Approach

If you have the installation CD / DVD, then insert the installation media into the drive to install SQL Server. Within the root folder, double-click on the setup.exe, as shown below.

Install SQL Server Management Studio 1

Once you click on the setup.exe, a new installation wizard called SQL Server Installation Center will open, as we have shown below. Next, go to Installation tab and click New SQL Server stand-alone installation or add features to an existing installation hyperlink

Install SQL Server Management Studio 2

First, the SQL Server installation process will check for the updates

Install SQL Server Management Studio 3

Next, it will enter into the Install Rules window. And here, setup will automatically advance and perform the operations. Here, it has to pass all the rules present in these windows, but you can leave this Windows Firewall warning.

Install SQL Server Management Studio 4

Once you click the Next button, it will enter into the Setup page. Please select the second option, i.e., Add Features to an existing instance of SQL Server because we want to add SQL Server management Studio to an existing instance. Please refer to the Install SQL Server to understand the first option, i.e., installing SQL Server completely.

Install SQL Server Management Studio 5

Feature Selection: Please select the features that you want to install into your computer. From the below screenshot, all the grayed out features previously installed in our local system.

To install SQL Server Management Studio, Please check mark Management Tools – Basic and Management Tools – Complete features and click the Next button.

Install SQL Server Management Studio 7

Click Install button

Install SQL Server Management Studio 8

Allow a few minutes to install SQL Management Studio completely. As you can see from the below screenshot, we successfully installed SQL Server Management Studio in our local system.

Install SQL Server Management Studio 10

Install SQL Management Studio Second Approach

I must say, this is the direct approach to install SQL Management Studio. Click on the Download hyperlink to go to the below-shown window. Next, Please click on the Download SQL Server Management Studio 17.4 hyperlink to start downloading the SSMS set up file

Install SQL Server Management Studio 11

Please click on Save File to save the setup file in your local hard drive

Install SQL Server Management Studio 12

Click the Install button to install SQL Server Management Studio

Install SQL Server Management Studio 13

Allow a few minutes to load packages required for SSMS and few other minutes to complete the installation of SQL Server Management Studio

Install SQL Server Management Studio 15

Let me check whether we successfully installed the SQL Server Management Studio or not. From the below screenshot, you can see the SSMS in recently added programs.

Install SQL Server Management Studio 16