Cannot connect to my database remotely via SSMS

05. MSSQL > 02. Connection
Cannot connect to my database remotely via SSMS
 
1) Check if TCP/IP is enabled on SQL Server Management console
2) Check if SQL port is open on Firewall
3) Restart the SQL Server and connect again
4) If still cannot connect, please run “ tracert ServerIP”, “ping ServerIP”, “telnet ServerIP SQLPort” on your local computer, and send the screenshot to email  support@databasemart.com. 
Please refer to the following steps:
1. Open "CMD" on your local server. To do that:
  Simultaneously press the Windows + R keys to open the run command box.
  Type cmd and press Enter.
To find the details of the network between your local server to our data center, please send the result of ping and tracert to support@databasemart.com. Please refer to the following steps:
 
2. Input “ping 45.35.0.3”, and then hit “Enter”. 
 
3. Please send us the screenshot of the command running result. For example:
 
4. Input “Tracert 45.35.0.3”, and hit “Enter”. Then, send us the screenshot of the “Tracert” command result. For example:
 
5. To find if it is the port issue, input “telnet 45.35.0.3 1433”, and hit “Enter”. Then, send us the screenshot of the “telnet” command result. For example:
This value "1433" depends on what the port of SQL is. This article takes 1433 as an example.
Article ID: 578, , Modified: February 25, 2021 at 2:10 AM

Add Feedback

Was this article helpful?

Share this article

Print