Sidebar

"The driver could not establish a secure connection to SQL Server" after 5.23.1 upgrade

0 votes
219 views
asked Mar 6, 2023 by jon-t-7005 (7,590 points)

After upgrading to 5.23.1, QIE won't start and the qieLauncher.log.0 shows "The driver could not establish a secure connection to SQL Server"

1 Answer

0 votes

Due to an upgrade to the MS SQL JDBC driver QIE uses, you may run into this error that prevents QIE from launching.  The problem is that the JDBC driver does not inherently trust the certificate provided by the MS SQL server.  This can occur even if you are not using an encrypted connection to the MS SQL database.

To remedy the situation, edit the JDBC connection string in the Arguments section of the Startup tab in the QIE Service Manager (or if on Linux or Mac, edit the qie.service file).  The JDBC connection string starts with -Dconnection.url=jdbc.  Add the following to the end of the line (do not forget the semicolon):

;trustServerCertificate=true

Press the Apply button, then start QIE.

answered Mar 6, 2023 by jon-t-7005 (7,590 points)
...