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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-04 : 15:13:30
|
| Kevin writes "We have been struggling for weeks to get a pull subscription to work over the internet. This morning our network administrator said "why not just do the replication over a VPN?"He points out that we could close all the firewall holes for replication (1433, etc) and also have secure data traveling across the tunnel at the same time.Is it possible to use a VPN for replication in SQL Server7 ? If so, is it easier or are there extra complicatons?Thanks a lot for any adviceKevin" |
|
|
johnsoar
Yak Posting Veteran
66 Posts |
Posted - 2001-12-04 : 23:41:09
|
| Yes it is possible and it is actually the most secure way. Replication over a VPN is like replication over a private network. It's much easier(read statement above again)! The only problem is performance degredation because data must be encrypted and then decrypted at the other end. I think WIN2k has addressed this issue with L2TP(a hybrid of PPTP and another protocol, L2F?) which can support multiple, simultaneous tunnels for each user rather than PPTP protcol(one tunnel per user) that shipped with NT4, but I'll leave it up to you to decide if performance is more important than security.Hope this helpsAdamEdited by - johnsoar on 12/05/2001 00:02:53 |
 |
|
|
|
|
|
Replication over a VPN ?