I am getting "A network-related or instance-specific error .... " when I try to connect to any external SQL server. I can connect to local server only external servers gives the error.
I am using SQL server 2017 and SSMS 14.
I have read the topic in
Why am I getting "Cannot Connect to Server - A network-related or instance-specific error"?
and tried the following solution mentioned their without any success:
- enable TCP/ip from SQL Server configuration Manager.
- try different internet providers.
- Upgrade SQL server to 2017.18.1
- Make sure all services are enabled and running.
- Restart services and the machine.
- Create azure SQL DB to use name instead of IP.
- turn off firewall.
Could you please help me or explain why that happen.