Menu

#873 SQL Server 2019 connection error due to certificate issue

4.8.1
closed-fixed
nobody
5
2025-02-22
2024-03-29
Denis Chenu
No

I try to connect to a database on a MSSQL server, it work with previous server wityhout issue, but MSSQL server was updated to the last version.
Last MSSQL need crypt (is good), you can allow connection without control without certificate with ;TrustServerCertificate=1 at end of connection.

Else : [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

There are no way to do this on current version.

(I try to hack manually connection string : strangely it don't work, i have another tool on same server and it work with this extra instruction ;TrustServerCertificate=1)

Server : IIS, PHP8.0 (fastcgi)

Discussion

  • Denis Chenu

    Denis Chenu - 2024-04-22
    Related PR : https://github.com/vrana/adminer/pull/481
    
     
  • Jakub Vrána

    Jakub Vrána - 2025-02-22
    • status: open --> closed-fixed
     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.