|
|
Posted by Erland Sommarskog on 09/12/06 21:22
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@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
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|