# 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:** 1\
**Showing post:** 2

<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.

---

_[View the full topic](https://forum.inductiveautomation.com/t/error-connection-sql-server-database-after-upgrade-ignition/53281)._
