MSSQL Connection Error "Cannot create PoolableConnectionFactory "

[jchen]

Hi there,

I tried to conenct MSSQL but got an error below:

My ignition version is 8.1.48, SQL server in installed on another server, the MSSQL version is 2022, operation system version is Server 2022.

I updated the MSSQL JDBC driver with the link in the user manual.

https://github.com/microsoft/mssql-jdbc/releases

Selected the jre11 version and updated the file in the MSSQL driver, not sure if this is the right JDBC file, tried jre8 also get the same error.

Has anyone encountered the same problem before? I have been able to connect to Microsoft SQL smoothly before, but it seems to be the first time I have encountered the need to update the JDBC driver.

Thanks.

[David_Stone]

That error indicates there is an issue with the SSL connection to MSSQL.
Is the dns name on the SSL certificate the same as the dns name you are connecting with?

[pturmel]

The server is presenting Ignition with a certificate that is self signed or signed by an authority that java doesn't include by default. Either:

• Add the signing authority to java's trust store, or

• Tell the JDBC driver to trust the server unconditionally. (The option for that is right there in the error message.)

[jchen]

I don’t have any SSL certificate, just simple connection to SQL server.

[jchen]

Added “;trustServerCertificate=true“ at Extra Connection Properties has solved the problem, thank you.