SQL server database replication between 2 different domains


  • 2 domains for 2 different offices in different locations

    Here are links:

    Under "snapshot agent security", may I still use domain account not local computer user account? because no local computer account is allowed in my current place.

    Can I use domain account instead of <Publisher_Machine_Name>\repl_merge, <Publisher_Machine_Name>\repl_snapshot and <Publisher_Machine_Name>\repl_distribution? 

    How to secure data replication transmit over internet as they are 2 different office in different locations?

    Wednesday, May 30, 2018 8:18 PM

All replies

  • 1) yes, you can use a domain account as opposed to a local machine account. 

    2) You would need to use a VPN for this. Most folks I know use OpenVPN, or Hamachi, or even a Microsoft vpn.

    Wednesday, May 30, 2018 8:28 PM
  • Have further question about domain account

    ServerA is under domain and has user account abc\user1

    Domain has user account 123\user2 trusts

    so may I use user account 123\user2 to create replication publisher on serverA(it is on domain If I use 123\user2, I will get error message "Not valid windows user..." when setup snapshot agent account.

    Any comments? Thanks

    Wednesday, May 30, 2018 10:54 PM
  • This should work as long as 123\user2 is in the db_owner role in the publication/distribution database on Server A.

    You may be able to use passthru authentication to get this to work.

    Note that you will likely need to deploy everything via script as opposed to using the gui.

    Thursday, May 31, 2018 11:00 AM