Transaction replication delivering data to third party on different domain.
Network admin is setting up Cross connect to third part server, network engineers opens up firewall to specific IP and port. Under sql server config. manager, SQL DBA can create alias assigning servername to ip and port and use SQL auth user to connect to third party server on different domain. Publication and subscription created on source and destination and its delivering data without any problem. Now tricky part > along with cross connect, network engineer wants to setup VPN connection as well as a backup in case of failover.
How can SQL server be configured automatically to adapt network failover and point to new IP and port ?
Example: if IP address 1.1.1.1 goes down, connect to 2.2.2.2, what can be done ?