SQL Cluster Connecting to Linked Server over a firewall.

Hi, Scenario: SQL FCI Cluster --> firewall (stateful) --> SQL Linked Server SQL cluster needs to connect to linked server at the other side of a firewall. Question: What needs to be ...

Cluster

firewall

Linked Server

sql

petevern
Jan 25, 2025
I would request to open all 3 as have seen cases using failover that the actual node is initiating the connection.
Source:
SQL Server VCO IP
Node 1 IP
Node 2 IP
Destination
SQL VIP (linked server)
Port
Normally 1433 but can also be a dynamic port so something to check.