Error connection SQL Server database after upgrade Ignition

[stefano.sforna]

Goodmorning,
I upgraded Ignition 8.1.5 to Ignition 8.1.12.
After upgrade, I have error of connection to database SQL SERVER 2014.
Before upgrade, database connection are ok.
See photo for error.

Why ???

[Kevin.Herron]

It probably has to do with TLS 1.2 support in SQL Server and the Java version changing when you upgraded to one that drops TLS 1.0/1.1.

Patching/upgrading SQL Server, re-enabling the deprecated TLS versions in Java, or rolling back to an earlier version are the only options I'm aware of.

Zulu64 JRE and Database Connection Faults

I believe this is due to TLS 1.0 and 1.1 being disabled starting in 8u291: https://www.java.com/en/download/help/release_changes.html You can update/patch your SQL server instances to support TLS 1.2: KB3135244 - TLS 1.2 support for Microsoft SQL Server Or there’s some way to re-enable TLS 1.0 and 1.1 in Java that I need to search for…

TLS 1.0/1.1 changes in OpenJDK and Amazon Corretto | Amazon Web Services

TLS 1.2 support for Microsoft SQL Server - SQL Server

[Emil_Holm]

Hi had the same issue after upgrading to 8.1.11, java updated to build 1.8 but the MSSQL driver 4.0 is not supporting that java version, after updating the driver to jdbc.9.4 everything worked perfectly.