SQL Server Create Availability Group Error

Buddha Li 25 Reputation points
2023-10-10T08:42:18.98+00:00

I failed to create availability group in MSSQL 2019 CU22. I found below error in cluster log. Anybody can help?

000020dc.0000112c::2023/10/10-08:15:20.355 INFO [RES] SQL Server Availability Group <AG2>: [hadrag] Connect to SQL Server ...

000020dc.0000112c::2023/10/10-08:15:20.370 ERR [RES] SQL Server Availability Group <AG2>: [hadrag] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]SSL Provider: The certificate chain was issued by an authority that is not trusted.

(590629)

000020dc.0000112c::2023/10/10-08:15:20.370 ERR [RES] SQL Server Availability Group <AG2>: [hadrag] ODBC Error: [08001] [Microsoft][SQL Server Native Client 11.0]Client unable to establish connection (590629)

000020dc.0000112c::2023/10/10-08:15:20.370 INFO [RES] SQL Server Availability Group <AG2>: [hadrag] Could not connect to SQL Server (rc -1)

000020dc.0000112c::2023/10/10-08:15:20.370 INFO [RES] SQL Server Availability Group <AG2>: [hadrag] SQLDisconnect returns following information

000020dc.0000112c::2023/10/10-08:15:20.371 ERR [RES] SQL Server Availability Group <AG2>: [hadrag] ODBC Error: [08003] [Microsoft][ODBC Driver Manager] Connection not open (0)

000020dc.0000112c::2023/10/10-08:15:20.372 ERR [RES] SQL Server Availability Group <AG2>: [hadrag] Failed to connect to SQL Server

000020dc.0000112c::2023/10/10-08:15:20.372 WARN [RHS] Online for resource AG2 failed.

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

2 answers

Sort by: Most helpful
  1. Erland Sommarskog 102.2K Reputation points
    2023-10-10T21:19:17.8666667+00:00

    Seems like you should install proper certificates for your instances and then put these certificates in the Trusted Certificates store of the other machines.


  2. AniyaTang-MSFT 12,326 Reputation points Microsoft Vendor
    2023-10-11T02:28:53.2733333+00:00

    Hi @Buddha Li

    For the error "The certificate chain was issued by an authority that is not trusted", please refer to this similar thread: https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn.

    You can also check out this documentation: "The certificate chain was issued by an authority that is not trusted" error after upgrading SNAC applications.

    Best regards,

    Aniya