Post reply

opening firewall ports to/from a SQL Server Cluster

  • June 22, 2015 at 3:11 am

    #301782

    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?

  • June 29, 2015 at 7:53 am

    #1808764

    After doing a packet level trace, we found that the only IPs used when replicating from a Cluster to a standalone SQL Server were the IPS address(es) of the Nodes themselves.

    Since either Node can be the active Node, we opened the following:

    source

    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

    Destination

    port 1433 (TCP)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply