I need to setup MS SQL Transactional Replication between two untrusted domains over the Internet.
One of the SQL Servers running sql2008 (the Publisher that acts as it's own Distributor
) is in a physical Co-Location and the other SQL Server running sql2012 (that is the Subscriber
) is in AWS with an EIP.
I started with Networking and have opened direct ports of the following on both the Co-location Firewall and in the AWS Security Group:
I am an administrator for both
Networks, so setting up close-to identical accounts between these two is completely possible.
I've already setup the Publisher and Distributor and I'm ready to connect to setup the Subscription but I can't figure out a good way to do this.
The actual "replication" I should be able to handle, but how the heck to I authenticate between these two SQL Servers so that I can add the Publication to the Subscriber Database?
Thanks in advance for your help!