SQL troubles with VPN connection

[Charles MacLean]

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.

[Erland Sommarskog]

Re: SQL troubles with VPN connection

Charles MacLean (charlesmaclean @sbcglobal.net) writes:

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.

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@sommarsk og.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

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx