Wednesday, November 14, 2012 7:21 AM
Currently i am using merge replication over LAN ... i am using anonymous pull subscriptions and i am using RMO API to fire the merge agent, and i am using integrated security for merge agent credentials, so my question is what the changes i might need to take care of if i need to move to VPN ?
Wednesday, November 14, 2012 1:17 PMModeratorNothing. It should just work. As long as you are able to resolve the name of the publisher from the subscriber over the VPN it will work fine.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
Thursday, November 15, 2012 9:55 AM
As Hilary Mentioned You dont have to do any change since the IP will remain same even over VPN so you can easily do it -
all you need to verify is the connectivity and ask your security team to open the ports you need.
Sarabpreet Singh Anand
This posting is provided , "AS IS" with no warranties, and confers no rights.
Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you. This can be beneficial to other community members reading the thread.