How To Install SQL Server Management Studio 2017

Vignesh Mani

3y487.9k11100Article

SQL ServerInstallation Way Of SSMSSQL Server Management Studio 2017

11 Comments

Join the conversation! Your thoughts help the community grow.

Pramod Peyyala7y ago
For My Pc it Doesn't showing server name, when i use, . or localhost not connected, even windows authentication also,
- Khaja Moizuddin7y ago
  Before installing need to install the dependency files.
- Khaja Moizuddin7y ago
  I mean need to uninstall the dependency files*
- Sundaram Subramanian7y ago
  How to remove the dependency files ?. I am not facing the same issue
Khaja Moizuddin8y ago
After downloading i am unable to connect to db with server name, is there any other possible way to connect to db.
Senthil Kumar8y ago
Great article sir, Could you explain more about how to open a new query window.
Pinki Yadav8y ago
Is this sql2017 is express idition or something else .as i want to use sql agent job in that.can i use this in sql 2017
- Senthil Kumar8y ago
  General SSMS version,
- Senthil Kumar8y ago
  By default, the SQL Server Agent service is disabled when SQL Server 2017 is installed unless the user explicitly chooses to autostart the service.
Kartik Pawar8y ago
Nice explanation... Thank you for sharing...
- Vignesh Mani8y ago
  Thank You Karthik.

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 for Server Management Studio 2017

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”.

Step 3, the “SSMS-Setup-ENU.exe” window will be open, click the save button for saving SQL Server Management Studio 2017 exe and the 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.

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

Step 6, The 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”

Step 7, After loading the 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.

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 the below screenshot. The opening the first time it will take a few minutes.

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.

Next > How to Set the Dark Theme of SQL Server Management Studio.