I have a SQL Server 2008 R2 cluster with two nodes (active/passive). Here's the configuration :
Cluster name : MYCLUSTER .
Cluster IP : 18.104.22.168
Node 1 (active node) hostname : NODE1
Node 1 IP : 22.214.171.124
Node 2 (passive node) hostname : NODE2
Node 2 IP : 126.96.36.199
Instance Name: MYCLUSTER/MYINSTANCE
Instance IP: 188.8.131.52
I need to have my Network Folks open the Firewall to allow SQL Replication Traffic to a SQL Server outside of our Network. We opened the Firewall using the IP of the SQL Instance (184.108.40.206) but that did not do the trick. Can someone tell me what IPs have to be opened at the Firewall to allow the Replication Traffic?