Diadem Technologies Support Knowledgebase

How to connect to MSSQL Server from local SQL Server Management Studio

Article ID: 1115
Last updated: 20 Jul, 2018

This article will guide you on how to connect to MS SQL Server from your local SQL Server Management Studio. You can obtain login details from VPS setup mail or by sanding a request to our support mail-id i.e. [email protected] from your registered mail-id. 

1. Go to Start -> All Programs -> Locate Microsoft SQL Server , Click on SQL Server Management Studio.

2. Enter following details in Connect to Server Window:

  • Server type: Database Engine
  • Server name: VPS_IP_address,5000
  • Authentication: SQL Server Authentication
  • Login: sa
  • Password: #Password provided in login details#

Click on Connect button. 

3. You are now connected to MSSQL Server.

This article was:  
Report an issue
Article ID: 1115
Last updated: 20 Jul, 2018
Revision: 1
Views: 329
Comments: 0