AG on Failover cluster mirroring endpoint

sakuraime 2,316 Reputation points
2021-04-13T03:16:01.273+00:00

I have a failover cluster sql 2016 and would like to build AG with another instance . and I create the mirroring endpoint .

Create endpoint AGENDPOINT
state=started
as tcp (listener_port=5022,LISTENER_IP = ALL)
for database_mirroring
( authentication=certificate agcert,role=all ,encryption=required algorithm aes)

however, the endpoint 5022 only listen on the Virtual IP of the Failover cluster .

how to make it listen to ALL address on the server ? thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,682 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2021-04-14T02:57:00.957+00:00

    Hi @sakuraime ,

    Welcome to Microsoft Q&A!

    When you create a new Transact-SQL endpoint, connect permissions for public are revoked for the default TDS endpoint. If access to the public group is needed for the default endpoint, reapply this permission by using the GRANT CONNECT ON ENDPOINT::[TSQL Default TCP] to [public]; statement.

    Please refer to Configure the Database Engine to Listen on Multiple TCP Ports and GRANT Endpoint Permissions (Transact-SQL) to get more information.

    Best regards,
    Carrin

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. kumar kaushal 176 Reputation points
    2021-04-14T10:16:25.483+00:00

    @sakuraime .. Does your cluster nodes are in different subnets , i assume they should be as you have configured SQL AG . When your nodes are in different subnet , every network name will be dependent on 2 Ip address resources ., Out of which only one IP will be online corresponding to that subnet from that resource group resides. That's how cluster is designed to work.

    0 comments