We have an application that connects to a remote site's SQL server using a
VPN client. It also uses a local MS SQL database located on one of our
servers. It seems once the VPN connection is established the client machine
is always looking to the remote VPN connection/server for it's data. I
tested this out by going into the ODBC applet and doing a "TEST CONNECTION"
with the VPN client closed. The response was immediate and the connection
worked. Once I established the Internet VPN connection the connection
repeatedly failed after a several seconds while it appeared to be looking on
the Internet for a local server.

What can we do to fix this problem.

Thanks,
Charles Maclean
MTS, Inc.

Charles MacLean (charlesmaclean@sbcglobal.net) writes:
[quoted text, click to view]

It sounds as if you have "Use default gateway on remote network" checked
for the VPN connection.

To investigate this, open the Properties for the network connection,
select the Networking tab. Select TCP/IP, and then Properties. Open
the Advanced button.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at