Managing SQL Servers using SQL Server Management Studio (SSMS)

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.

Solution


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

image

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 15_26_23-itlab.yamana.com - Remote Desktop Connection Manager v2.2

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

2017-05-14 17_27_52-itlab.yamana.com - 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.

image