Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
stevenmu
Starting Member
1 Post |
 Posted - 2006-05-15 : 12:18:57
|
| Hi all,little connectivity problem, I hope this hasn't been asked before, I've tried searching and haven't found much sign of it.We have an app which runs on sales reps laptops using MSDE (or in this particular case SQL 7 Desktop Edition) and uses merge replication to send up orders, pull down products etc. All worked fine untill we set it up for one particular customer who wanted to use their existing SQL 7 install with it and a VPN connection for replication. The problem is that with the VPN connected nothing (the app, the merge dll or even enterprise manager) could connect to the local instance (but can see the main server across the VPN). It seems to be some kind of funny routing issue whereby the VPN software sends local traffic off across the VPN which has no idea what to do with it. Using the Client Network Utility I've been able to setup an alias for the local machine forcing it to use named pipes, which worked brilliantly allowing access when connected to the VPN and allowing replication to work. Unfortunatly with this enabled the problem now occurs when the laptop is disconnected, nothing can connect to the local instance. I'm kind of a newbie wrt to managing SQL server, can anyone suggest anything on how I should be setting this up ?Thanks in advance,Steve. |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2006-05-16 : 04:31:02
|
| This is not a SQL Server issue, it's a VPN / Network routing issue. Try looking up the support docs for the VPN solution and seeing how to fix routing where it's sending traffic to the wrong area. Will probably be something to do with changing the route metrics for certain traffic.-------Moo. :) |
 |
|
|
|
|
|
Connectivity issues (TCP/IP, Named Pipes etc)