[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection.

Question

Hello, researched and around still having issues on connecting into SQL Server.

Error getting is:

[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection.

To point out the end user had an older computer that was able to connect into SQL Server and notice that computer had Microsoft ODBC Driver 13 and 17 for SQL Server (& Microsoft OLE DB Driver for SQL Server) installed within the Programs and Features... but this new computer having this issue has only "Microsoft ODBC Driver 18 for SQL Server" installed.

Any thoughts please?

Thanks in advance.

Answer 1

Hi @techresearch7777777

but this new computer having this issue has only "Microsoft ODBC Driver 18 for SQL Server" installed.

According to this doc: "The certificate chain was issued by an authority that is not trusted" error after upgrading SNAC applications.

If you recently upgraded your SQL Server Native Client 11.0 (Driver={SQL Server Native Client 11.0}) application to Microsoft ODBC Driver 18 for SQL Server (Driver={ODBC Driver 18 for SQL Server}), you might receive these error messages.

Then try below solutions:

Solution 1: Use the Microsoft ODBC Driver 17 for SQL Server. You can download the driver from Download ODBC Driver for SQL Server.

Solution 2: If the application connection string property already specifies a value of Yes or Mandatory for Encrypt setting, change the value to No or Optional. If the value isn't already specified, add Encrypt = Optional;. If you're using a DSN, change the encryption setting from Mandatory to Optional. For more information, see DSN and connection string keywords and attributes.

Best regards,

Cosmog

---

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