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
Hello Folks,
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:
- 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
-
Added security logins in SSMS -- NT AUTHORITY\NETWORK SERVICE
-
Enabled TLS 1.4 as my version is V4.0.30319
-
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