I have an SQL Server 2012 server set up replicating one Database. It is behind a firewall. I have poked a hole in the firewall so I can access the server on Port 1433. I am using an IP Address and a different port number to access from a external hosted 2016 Sql Server.
When I try to subscribe to the Replicated database the Subscription goes thru, however the Job continually fails with "Cannot access Distribution Server [RemoteSQLServerName]"
How can I modify the Job/script to make it point an IP Address and a Port number?