I have two servers - one located in Australia (Distributor / Publisher), and a second in the UK (Subscriber) both on Amazon's cloud. I have attempted to configure replication as both pull and push with neither configuration giving me any joy. I have configured the security such that there is no TCP block between the two servers (with fixed IP addresses)
In the pull scenario, the UK server connects to the AU server okay, and fails to obtain the subscriber object list. It comes back with a TCP Semaphore issue and crashes out. I can't for the life of me figure out what would be causing that as I can connect to the AU server through the Management Studio without any issues at all and pull back some large queries.
In the push scenario, the AU server connects to the UK server and gets about half an hour into the initialization and then, on the same table, which disappears, every time, crashes out. The table itself is dropped - and a few times I've watched the process get to that point, see the table being dropped, and manually re-scripted it. After the table drops, the AU server reports a connection issue, and will reconnect in about 20 seconds - it's during that window I've attempted to recreate the table - it eventually crashes out with a message complaining. It's always the exact same table each time, which makes me think that it's not a network issue.
Anyone with some ideas here?