August 6, 2009 at 7:46 am
Hi, we want to replicate a database from our company onto the network of one of our clients.
The replication would be Snapshot or Transactional with Push Subscription. The data would ony be updated at the Publisher.
Can anyone give me any pointers or advice regarding the network issues. I'm not sure about how we would handle security, firewalls, encryption etc..
Thanks
Allen
August 6, 2009 at 12:34 pm
Hi Allen,
See if it is possible to get VPN connection between the networks. If so, your job is easy. Also you will need to have tcp port 1433 and UDP port 1434 open to set up replication. Once replication is set up you can close UDP port 1434. (UDP port 1434 is not considered safe so close it after you have finished set up). Make sure you use create two windows account with same name and same password in both the network. Then you can sue windows Authentication itself without much issues.
I am sure other will chip in with more tips.
-Roy
August 12, 2009 at 5:17 am
Thanks Roy
VPN may be out of the question because of security concerns even though for me it would seem to be the simplest to administer, my other option seems to be using FTP for the snapshot folder.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply