MSSQL Connection Fault


Hello Folks,

I am trying to connect with MSSQL 2022 and Ignition V8.1.22, There are some relevant posts, but I could not figure out what needs to be done exactly.

Regards,
SPI

Some topics for you:

https://forum.inductiveautomation.com/search?q=SQL%20Server%20javax.net.ssl.SSLHandshakeException

2 Likes

Thank you @pturmel

Finally, my connection is made with the database.

with the following steps:

  1. Updated the JDBC drivers JAR file with interactions from IA and DLL file

C:\Program Files\Inductive Automation\Ignition\lib (Copied .dll file in this path/mssql-jdbc_auth-12.2.0.x64.dll)

C:\Program Files\Inductive Automation\Ignition\lib\core\gateway

  1. Added security logins in SSMS -- NT AUTHORITY\NETWORK SERVICE

  2. Enabled TLS 1.4 as my version is V4.0.30319

  3. Extra connection properties in the ignition gateway - databaseName=Test;Integrated Security=true;encrypt=false;

"That's all I remember - it was fixed, and its status is now valid after I spent the whole day working on it."

1 Like