SQLTeam.com | Weblogs | Forums

Opening Firewall Port to allow SQL replication Traffic to/from a SQL Cluster


#1

I have a SQL Server 2005 cluster with two nodes (active/passive). Here's the configuration :

Cluster name : MYCLUSTER .
Cluster IP : 123.123.0.10
Node 1 (active node) hostname : NODE1
Node 1 IP : 123.123.0.11
Node 2 (passive node) hostname : NODE2
Node 2 IP : 123.123.0.12
Instance Name: MYCLUSTER/MYINSTANCE
Instance IP: 123.123.0.13

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 (123.123.0.13) 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?


#2

Replication usually just uses the default ports of the instance. Opening up 123.123.0.13 should be enough.

I'm assuming that the firewall is also open to the distributor and subscriber(s)?

Is SQL Server running on port 1433?