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 firstname.lastname@example.org
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 email@example.com. Please refer to the following steps:
2. Input “ping 18.104.22.168”, and then hit “Enter”.
3. Please send us the screenshot of the command running result. For example:
4. Input “Tracert 22.214.171.124”, 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 126.96.36.199 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.