May 29, 2009 at 6:41 am
Hi All,
We are planning to configure Transaction replication between two different domain( Over VPN).
Please do let me know how to do this?
SQL Server 2005 ENT edition with sp2.
"More Green More Oxygen !! Plant a tree today"
May 29, 2009 at 7:40 am
Couple of things to keep in mind when doing this. Make sure that port 1433 is open and UDP port 1434 is open between the two server. 1434 is need for the SSMS to be able to connect. Make sure that there is a DNS entry for the subscriber in the publisher domain and vice versa. This is because the Replication does not work with IP. It has to be computer name.
You can use SQL Authentication or windows Authentication for the replication set up. I dotn have the step by step procedure but I have set it up when the publisher is one continent and the subscriber is on another. Since it is a VPN connection, it should not be an issue. Only issue that will there is rights to access the snapshot folder and the ports open on the firewall.
-Roy
May 29, 2009 at 7:45 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply