We would like to set up replication between two SQL Server 2012 instances.
Server "Internal" can see and make connections to server "External". External is completely firewalled from the internal network. No inbound connections are allowed on any port.
We want to set up transactional replication from internal to external for a read-only copy on server External. When configuring External as the subscriber, it wants to connect to the publisher which it cannot do.
All my searching leads me to articles on which ports to forward but that is not going to work for us. Basically what we want to do is have Internal initiate the connection and push updates to a copy on External. Up until now we have been using SSIS packages to push data but it's starting to border on unmanageable.