How To Install SQL Server Management Studio 2017

This article explains how to download and install SQL Server Management Studio 2017.

Introduction

This article explains how to install SQL Server Management Studio 2017 in a step by step way. The current version of SSMS is 18.0. To learn, how to install it, visit How to Install SQL Server Management Studio 18.0.

Installation Steps

Step 1

Go to this link for downloading SQL Server Management Studio 2017.

Step 2

We can see that it looks like the below screenshot after entering the above link, click “Download SQL Server Management Studio 17.8.1”.

SQL Server

 

Step 3

“SSMS-Setup-ENU.exe” window will be open, click save button for saving SQL Server Management Studio 2017 exe and download will start.

SQL Server

Step 4

Go to your downloaded path and you will see the exe. Double click the exe for starting the installation.

SQL Server

 

Step 5

After double clicking, the system will ask the permission:  “Do you want to allow the following to make a change this computer?”.  Click yes to continue installing the SQL Server Management Studio 2017.

SQL Server

 

Step 6

Installation window will be open after giving permission to install. Click the Install button, the install will start. After clicking, the install button will show as “Loading Packages Please Wait”

SQL Server

 

Step 7

After loading packages progress bar will be shown. One is Package Progress and Overall Progress. We can see that it looks like the below screenshot.

SQL Server

Step 8

Installation completed. After completing the installation, we can see it looks like the below screenshot. Now click the close button and restart your computer.

SQL Server                                                                                

Step 9

Go to all programs in your systems, we can see two folders one is Microsoft SQL Server 2017 and another one is Microsoft SQL Server Tool 2017. Under Microsoft SQL Server Tools 17 can see the Microsoft SQL Server Management Studio 17.

SQL Server

Step 10

Double-click SQL Server Management Studio 17 and it will open looks like below screenshot. The opening the first time it will take a few minutes.

SQL Server

 

After opening SQL Server Management Studio 2017, we can see it looks like the below screenshot.

SQL Server

Now we can connect to the server and use the SQL Server Management Studio 2017.

Conclusion

This article explained how to install SQL Server Management Studio 2017 step by step. I hope it is very helpful for new learners.