0 votes
in Rock by KateQuinn (6.8k points)
edited

I am having trouble logging in to Central Az's SQL server instance. I can connect to their vpn but I cannot get SSMS or Azure Data Studio to login properly. I was able to do so last week without a problem...why has it stopped working?

Here are the error messages I'm receiving:

enter image description here

When I ping the vpn and sql server, I get mixed results:

enter image description here

1 Answer

0 votes
by KateQuinn (6.8k points)
edited
 
Best answer

The error messages aren't descriptive: I get the same error messages whether I have an incorrect password, am being blocked by the firewall, or (in this case) my DNS is not resolving properly. Here is how I fixed this issue:

1.) Test with 9embers vpn and Cisco vpn.

2.) Test using only Cisco vpn.

3.) Ping the vpn and the sql server address - in a vpn scenario, the sql server "should" (might?) be added in a subnet. The sql server address here should NOT be 162.213.43.147. It should be 10.200.4.96. In this case, my DNS is not correctly resolving the server at SQL191.centralaz.com.

4.) In this case, I restarted my computer. This logged me out of all the vpns and, after I re-connected to cisco, provided the correct subnet ip address during pinging:

enter image description here

Welcome! Here you can ask questions and receive answers (hopefully) from other members of our team.
...