This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 81%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
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?
Did you create the endpoints with CREATE ENDPOINT? Also, typically you arrange for permissions on the endpoints with certificates. Did you do that?
Yes certificates were needed and in SQL Server Configuration Manager I went to the properties of my instance and under Flags I chose Force Encryption = Yes. Under Certificate I chose the certificate of the server.
You have accepted my answer, which suggests that the issue is sorted out. However, the certificates you talk about are not related to the endpoints for the AG. This is a certificate that you create with CREATE CERTIFICATE and then copy to the other server with BACKUP CERTIFICATE.