SQL AlwaysOn setup - This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.

Question

Hi All,

This secondary replica is not connected to the primary replica. The connected state is DISCONNECTED.

When checked the logs found the below error:

A connection timeout has occurred while attempting to establish a connection to availability replica 'XXXX'
with id [XXXXXX]. Either a networking or firewall issue exists, or the endpoint address provided
for the replica is not the database mirroring endpoint of the host server instance.

Database Mirroring login attempt failed with error: 'Connection handshake failed. An OS call failed:
(80090302) 0x80090302(The function requested is not supported). State 66.'. [SERVER: XXXXX]

Any idea how to fix this?

Answer 1

Hi @SSG ,

Welcome to Microsoft Q&A!
Your error indicates that you may not use the same account on all machines. Check in the following way.

You should log in with the same domain account on all nodes.
In my case, my domain account password has expired or if I actively change it, there will be such an error.
Finally, hope your problem could be solved.

Best regards,
Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.

Answer 2

Another potential root cause for these messages could be a local policy named

Network Security: Restrict NTLM: Incoming NTLM traffic with 'Deny all accounts' value instead of 'Allow all'.