Ok, forum, please help! After hours of trying I'm at a loss.
I am attempting to set up Transactional Replication to a DMZ server. All the ports are open and configured, sql servers registered, aliases set up, etc. Publication also set up, and Snapshot runs successfully. Finally, when I go to PUSH the subscription, I continue to get the error:
The process could not connect to Subscriber
To complicate matters, both servers on either end are clustered. I did create a local account on both servers, with same username and password, and configured it for the SQLAgent on both sides.
In the subscription properties, I use a sql authenticated account, and tried service account as well.
I set up the alias using the IP address and TCP\IP.
What am I doing wrong! Please help me.................TIA