Windows Server Failover Clustering/SQL Server Firewall Access Rule

Merhaba, DC, Cluster ve SQL Cluster kurulumu için gereksinim olan portlar aşağıdaki gibi olmalıdır. Yararlı olması dileğiyle Windows Server Clustering – TCP/UDP Port Description TCP/UDP 53 User & Computer Authentication [DNS] TCP/UDP 88 User & Computer Authentication [Kerberos] UDP 123 Windows Time [NTP] TCP 135 Cluster DCOM Traffic [RPC, EPM] UDP 137 User & Computer Authentication [NetLogon, NetBIOS] UDP 138 DSF, Group Policy [DFSN, NetLogon, NetBIOS Datagram Service] TCP 139 DSF, Group Policy [DFSN, NetLogon, NetBIOS Datagram Service] UDP 161 SNMP TCP/UDP 162 SNMP Traps TCP/UDP 389 User & Computer Authentication [LDAP] TCP/UDP 445 User & Computer Authentication [SMB, SMB2, CIFS] TCP/UDP 464 User & Computer Authentication [Kerberos Change/Set Password] TCP 636 User & Computer Authentication [LDAP SSL] TCP 3268 Microsoft Global Catalog TCP 3269 Microsoft Global Catalog [SSL] TCP/UDP 3343 Cluster Network Communication TCP 5985 WinRM 2.0 [Remote PowerShell] TCP 5986 WinRM 2.0 HTTPS [Remote PowerShell SECURE] TCP/UDP 49152-65535 Dynamic TCP/UDP [Defined Company/Policy {CAN BE CHANGED}]

SQL Server – TCP/UDP Port Description TCP 1433 SQL Server/Availability Group Listener [Default Port {CAN BE CHANGED}] UDP 1434 SQL Server Browser UDP 2382 SQL Server Analysis Services Browser TCP 2383 SQL Server Analysis Services Listener TCP 5022 SQL Server DBM/AG Endpoint [Default Port {CAN BE CHANGED}] UDP 49152-65535 Dynamic TCP/UDP [Defined Company/Policy {CAN BE CHANGED}]

Active Directory Traffic: Source IP Range : Server’s IP Range Destination IP Range [Active Directory Servers] TCP Ports 53,88,389,464,636,3268,3269 UDP Ports 53,88,389,464

SCOM/SNMP Traffic: Source IP Range [SCOM/SNMP Servers] Destination IP Range 10.10.33.192/26, 10.11.33.192/26 TCP Ports 162 UDP Ports 161,162

Windows Server Failover Clustering Traffic: Source IP Range : Server’s IP Range Destination IP Range 10.11.33.192/26, 10.10.33.192/26 TCP Ports 135,139,445,1433,2383,3343,5022,5985,5986 UDP Ports 137,138,445,1434,2382,3343,49152-65535

Windows Time Traffic: Source IP Range : Server’s IP Range(Node’s IP Subnet) Destination IP Range [NTP Servers] TCP Ports N/A UDP Ports 123

Client SQL Server Access Traffic: Source IP Range [Client Application Servers] Destination IP Range : Server’s IP Range TCP Ports 1433,2383 (If default port used) UDP Ports 1434,2382