How To Connect to Your MSSQL Database (SSMS)

You will need to have Microsoft SQL Server Management Studio (SSMS) installed to complete these steps. Microsoft SQL Server Management Studio (SSMS) is available for free from Microsoft and can be downloaded through the following links:
Version Supported Operating Systems Article Link
SSMS 18.x (SQL Server 2017 & 2016) Windows 10 & Windows 8.1
  1. Once downloaded, open Microsoft SQL Server Management Studio (SSMS)
  2. Connect to the Server with the server name and login credentials 
    • It is recommended that you use the IP address of your domain instead of the domain name, as using the domain name could be affected by DNS
    • Your login credentials might be located within your web.config in the connection-string area as UID and PWD
  3. On the left navigation bar click on Databases

Additional Information
All Microsoft SQL Servers on's network run on the standard MS SQL Server port of 1433.  Sometimes, when trying to connect to your database, you may receive an error like this:

SQL server does not allow remote connections
If you receive an error stating that SQL server doesn't allow remote connections, your ISP (CenturyLink, Comcast, Cox, RoadRunner, Verizon, etc) is blocking you from connecting to SQL server. In order to resolve that problem, you will need to contact the company providing you with internet access and have them unblock port 1433.


Add Feedback