What are the port requirements for Distributed Availability Group (DAG)?

Bayu Aji Setyawan 0 Reputation points
2024-09-30T08:18:48.19+00:00

I plan to implement DAG with below topology (winserver 2019, sql server 2019):

DC A:

  1. Primary DC
  2. Secondary DC
  3. Quorum witness

DC B:

  1. Primary DRC
  2. Secondary DRC
  3. Quorum witness

Notes:

  1. Seperated replication and access IP

Question:

  1. What is all of the complete port requirement for Distributed Availability Group (DAG), including wsfc, etc..
  2. It's description on why those port need to be allowed.
  3. Which port on VM that need to be allowed? (ex: Primary DC/Secondary DC/Primary DRC/Secondary DRC/Quorum witness DC/Quorum witness DRC)
  4. Please attach with microsoft official documentation.
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,788 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,201 Reputation points Microsoft Vendor
    2024-09-30T09:01:19.3233333+00:00

    Hi @ Bayu Aji Setyawan

    I did not find the MS document for port requirement of DAG, but you can refer to MS document Configure a distributed Always On availability group, port 5022 is listed.

    Searched this information online, please check.

    For SQL Server:

    • TCP 1433: This is the default port for SQL Server. If you've configured a different port for your SQL Server instance, make sure that port is open.
    • TCP 5022: This port is used for database mirroring endpoints, which are crucial for communication between the primary and secondary replicas in the DAG.

    For Windows Server Failover Clustering (WSFC):

    • UDP 3343: Used for cluster service communication.
    • TCP 135: Used for RPC (Remote Procedure Call) communication.
    • TCP 445: Used for SMB (Server Message Block) communication.
    • TCP 139: Used for NetBIOS session service.
    • UDP 137 and 138: Used for NetBIOS name resolution and datagram service.

    For Availability Group Listener:

    • TCP 1433: This is the default port for the availability group listener. If you've configured a different port for the listener, make sure that port is open.

    Additional Ports:

    • TCP 2383: Used for SQL Server Analysis Services.
    • TCP 2382: Used for SQL Server Browser service.

    If the answer is helpful, please click "Accept Answer" and kindly upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.