Alex Rivera | Logout

Not connecting to SQL Server over VPN

Asked 2009-03-21T14:22:34.623
22

I have connected for the first time to an existing network over VPN. I can ping the IP address which is used by the SQL Server from the VPN client, but SSMS does not connect to the SQL Server. I am using the right login id and password.

Why could this happen? Any ideas?

sql-server-2005 vpn
Edit
Report

2 Answers

7

When this happens to me, it is because DNS is not working properly. Try using the IP address instead of the server name in the SQL Server login.

answered 2009-03-21T14:31:06.130
1

SQL Server uses the TCP port 1433. This is probably blocked either by the VPN tunnel or by a firewall on the server.

answered 2009-03-21T14:28:51.613

Your Answer