Install SSMS on client

MSSQL-Feature-Image

SSMS stand for “SQL Server Management Studio”.
It is used to manage SQL server and/or Azure SQL Database.
It can be download at ” Donwload SSMS at Microsoft

Before install SSMS, we will join client in domain (joeschoice.com).

After install SSMS, we need to create inbound firewall rule at MS SQL Server of TCP 1433 port. It is because by default MS SQL Server will not auto create firewall rule.
Be default, MS SQL Server will listen TCP 1433 port, this port can be changed.
We can check the firewall by run “telnet DC01 1433” at client.

Besides, we need enable “Windows Management Instrumentation (DCOM-In)” and “Windows Management Instrumentation (WMI-In)“. If we does not enable these rules, SSMS will be unable to view and control the status of  “SQL Server” and “SQL Server Agent

How to install SSMS on client:

Author: Joe Chan