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

techresearch7777777 1,901 Reputation points
2024-11-05T17:45:22.7233333+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,119 questions
{count} votes

Accepted answer
  1. LiHongMSFT-4306 29,031 Reputation points
    2024-11-06T01:54:31.02+00:00

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

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.