A connection timeout has occurred while attempting to establish a connection to availability replica

Dave 20 Reputation points
2023-08-01T12:28:12.01+00:00

Hi all,

I setup a two node AlwaysOn AG in SQL 2019 Standard but the second node is not able to join the cluster. I checked the error logs and I saw this message: A connection timeout has occurred while attempting to establish a connection to availability replica 'server1\instance1' with id [xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx]. 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.

The firewall allows the correct ports through. The SPNs have been setup correctly. I can ping both servers from each other successfully. I am using the same domain account on both servers. Any ideas?

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,245 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 98,731 Reputation points
    2023-08-01T21:33:48.4633333+00:00

    Did you create the endpoints with CREATE ENDPOINT? Also, typically you arrange for permissions on the endpoints with certificates. Did you do that?


0 additional answers

Sort by: Most helpful