locked
SQL Server 2008 Replication over internet RRS feed

  • Question

  • I want to run replication (using transactional pull) between 2 SQL servers over the internet. What are my options. There is no VPN. Web Sync may not be possible because of data volume.
    Thursday, December 29, 2011 5:35 PM

Answers

All replies

  • The 2 options for implementing Replication over the Internet are to use a VPN or use Web Synchronization for Merge Replication.  I'm aware of no other options.

    Thursday, December 29, 2011 5:48 PM
  • Service Broker may work here as you can encrypt it end to end - however it requires a lot of work on your end and it does not scale to the way that transactional replication does.

    Note that you can replicate without a VPN but it is inherently insecure. You can do things like set up your firewall to only accept inbound communication from fixed IP addresses which represent your subscribers.


    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, December 29, 2011 6:04 PM
    Answerer
  • Hi Hilary,

    As you have mentioned, we have firewall where we can setup rules to only accept inbound communication from fixed IP addresses.

    I have configured the Distributor & Publisher as required. The Distributor & Publisher are on the same server and this server is in LAN. Let's call this server Server1

    The subscriber say Server2 however is not in LAN. Hence the windows process account being used by the Distribution Agent is not recognized on Server2. And hence the Subscription setup is failing. The option to use SQL server login is also disabled and I am forced to impersonate the process account which is not valid on Server2 as it is not in LAN and hence not in domain. I am able to access db on Server1 from Server2.

    /Tecguy1

    Friday, December 30, 2011 5:15 AM
  • Try using a local machine account on both machines with the same name and password.
    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
    • Marked as answer by Maggie Luo Thursday, January 5, 2012 6:39 AM
    Friday, December 30, 2011 3:11 PM
    Answerer