We are using Ignition version 7.9.8 (b2018060714) with java 1.8.0_171-b11 and Windows Server 2016
We are trying to connect to SQL Server, I am using the sa account.
We get the following error:
Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “SQL Server did not return a response. The connection has been closed.”.)
So far we checked the forum and followed the instructions in this topic:
But still isn’t working.
I also checked this topic Ignition cannot connect to SQL Server but that didn’t work for me
My connection string is as follows
I read another topic (SQL connection) which mentions downgrading the java jre. But this might affect other applications as well.
Is there any other possibility to make this works?