Managing SQL Servers using SQL Server Management Studio (SSMS)

Share this:

Installing Microsoft SQL Server Management Studio allows the administrator to manage SQL Servers, the tool allows management of SQL 2008 up to 2107 (if you are using the release candidate tool). The first step is to download the tool from the following page here.


The installation is really simple, after downloading the tool, click on Install.


The installation process will take some time to complete, but there is no options to be configured at this time, just wait for the completion of the process.

2017-05-14 - Remote Desktop Connection Manager v2.2

The downside of the process is that it will ask for a restart.

2017-05-14 - Remote Desktop Connection Manager v2.2

Automating the installation process…

In some cases, the administrator may want to automate the installation process and we can get the same results above by running the following command. This command will install the SSMS in a silent mode and no restart will happen. The administrator has to remember to restart the server/workstation afterwards to complete the process.

SSMS-Setup-ENU.exe /install /quiet /norestart

Using SSMS…

Now it is the easy part which is the SQL Management. We can open the Microsoft SQL Server Management Studio, and from there select the server name and start managing the SQL Server.


Written by Anderson Patricio

Anderson Patricio

Anderson Patricio is a Canadian MVP in Cloud and Datacenter Management, and Office Server and Services, besides the Microsoft Award he also holds a Solutions Master (MCSM) in Exchange and several other certifications. Anderson has been contributing to the Microsoft Community with articles, tutorials, blog posts, twitter, forums and book reviews. He is a regular contributor here at,, and Anderson (Portuguese).