question

sakuraime avatar image
0 Votes"
sakuraime asked CarrinWu-MSFT commented

AG on Failover cluster mirroring endpoint

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-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @sakuraime, we didn't get a reply from you, any update for this question?

0 Votes 0 ·
CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT commented

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

no.. I mean 5022 port can only map to the VIP in this situation ??

as for a single sql instance ,
Create endpoint AGENDPOINT
state=started
as tcp (listener_port=5022,LISTENER_IP = ALL)

will listen on ALL IP.

0 Votes 0 ·

Hi @sakuraime, sorry for the misunderstanding. Here has a similar thread with yours. Could you please try to add the secondary IP into server name cluster resource as a dependency? and then restart SQL service.

0 Votes 0 ·
kumarkaushal-1277 avatar image
0 Votes"
kumarkaushal-1277 answered

@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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.