# Error connection SQL Server database after upgrade Ignition

**URL:** <https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281>\
**Category:** Ignition\
**Created:** [November 19, 2021, 11:12am UTC](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281 "2021-11-19T11:12:48Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefano.sforna](https://avatars.discourse-cdn.com/v4/letter/s/91b2a8/32.png) [@stefano.sforna](https://forum.inductiveautomation.com/u/stefano.sforna)\
**Post date:** [November 19, 2021, 11:12am UTC](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281/1 "2021-11-19T11:12:48Z")

</div>

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.

 ![error_database](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/3/d3decfb21408ca5b6c2480a1ce7f377794357860.jpeg)

Why ???

---

<div class="post-metadata">

**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\
**Post date:** [November 19, 2021, 1:32pm UTC](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281/2 "2021-11-19T13:32:00Z")

</div>

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](https://forum.inductiveautomation.com/t/zulu64-jre-and-database-connection-faults/47152/2):
>
> 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](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](https://support.microsoft.com/en-us/topic/kb3135244-tls-1-2-support-for-microsoft-sql-server-e4472ef8-90a9-13c1-e4d8-44aad198cdbe) 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](https://aws.amazon.com/blogs/opensource/tls-1-0-1-1-changes-in-openjdk-and-amazon-corretto/)**
>
> Starting on April 20, 2021, quarterly update releases of OpenJDK are disabling TLS1.0 and TLS1.1 availability by default in all versions of OpenJDK. Amazon Corretto will be keeping TLS1.0 and TLS1.1 available by default for a while longer. Feedback...

> **[TLS 1.2 support for Microsoft SQL Server - SQL Server](https://learn.microsoft.com/en-US/troubleshoot/sql/database-engine/connect/tls-1-2-support-microsoft-sql-server)**
>
> This article provides information about the updates that Microsoft releases to enable TLS 1.2 support for SQL Server.

---

<div class="post-metadata">

**Author:** ![Emil\_Holm](https://avatars.discourse-cdn.com/v4/letter/e/c37758/32.png) [@Emil\_Holm](https://forum.inductiveautomation.com/u/Emil_Holm)\
**Post date:** [November 23, 2021, 12:45pm UTC](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281/3 "2021-11-23T12:45:53Z")

</div>

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.