XP VPN with uncheck "Use default gateway on remote network" & SQL server

[mtczx232]

Puja Pandey[MSFT] - Reply me How I can continue Access to my Internet
while I connect to Office by VPN. by uncheck the option "Use default
gateway on remote network"

I try it, it's working, but now I have Another problem:
When I connect to the office with uncheck "Use default gateway on
remote network" , I cannot connect to office SQL server (I got standard
Error of connection fail: 10060), I try also with IP instead server
name and result is the same. when I reconnect with check: "Use default
gateway on remote network" it's work smoothly.
(the remote is sql2000, and client is SQL2005 studio on TCP/IP
connection option)

So why files can be access by Explorer (this Improve that VPN work) but
SQL cannot be connect? and How solve this problem?


===============Original reply from Puja
Pandey[MSFT]=======================

Uncheck the option for "Use default gateway on remote network" and then
try.

To do this, on client -
- Go to network connections
- Right click on VPN connection and open properties page
- Go to networking tab
- Click on "Internet Protocol (TCP/IP) properties.
- Click on properties -> Advanced -> Then uncheck the check box for
"Use
default gateway on remote network"

 

[mtczx232]

I have mistake. when I type the IP of SQL server the connection work. I
understand that it cannot access by server name under uncheck "Use
default gateway on remote network" as result on DNS issue.

 

[Robert L [MVP - Networking]]

Sound like name resolution issue. Do you have WINS server? It is better to have WINS server for VPN name resolution. These search results may help,

vpn name resolution and brosingQ: VPN name resolution and browsing. After I successfully connect to the VPN Server remotely, I cannot browse the network, and see other computers and ...
http://www.chicagotech.net/Q&A/vpn1.htm

Does Windows 2000/2003 domain needs WINSDoes Windows 2000/2003 domain needs WINS. Q1: Is there a definitive list of the services and operations that will no longer work in Windows 2003 Server if ...
http://www.howtonetworking.com/server/wins1.htm



Bob Lin, MS-MVP, MCSE & CNE
Networking, Internet, Routing, VPN Troubleshooting on http://www.ChicagoTech.net
How to Setup Windows, Network, VPN & Remote Access on http://www.HowToNetworking.com
Puja Pandey[MSFT] - Reply me How I can continue Access to my Internet
while I connect to Office by VPN. by uncheck the option "Use default
gateway on remote network"

I try it, it's working, but now I have Another problem:
When I connect to the office with uncheck "Use default gateway on
remote network" , I cannot connect to office SQL server (I got standard
Error of connection fail: 10060), I try also with IP instead server
name and result is the same. when I reconnect with check: "Use default
gateway on remote network" it's work smoothly.
(the remote is sql2000, and client is SQL2005 studio on TCP/IP
connection option)

So why files can be access by Explorer (this Improve that VPN work) but
SQL cannot be connect? and How solve this problem?


===============Original reply from Puja
Pandey[MSFT]=======================

Uncheck the option for "Use default gateway on remote network" and then
try.

To do this, on client -
- Go to network connections
- Right click on VPN connection and open properties page
- Go to networking tab
- Click on "Internet Protocol (TCP/IP) properties.
- Click on properties -> Advanced -> Then uncheck the check box for
"Use
default gateway on remote network"