# Database connection error "connection reset"

**URL:** <https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [July 5, 2023, 5:37pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952 "2023-07-05T17:37:59Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brent\_Osterkamp1](https://avatars.discourse-cdn.com/v4/letter/b/ebca7d/32.png) [@Brent\_Osterkamp1](https://forum.inductiveautomation.com/u/Brent_Osterkamp1)\
**Post date:** [July 5, 2023, 5:37pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/1 "2023-07-05T17:37:59Z")

</div>

We are getting the following error on a table.

> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "Connection reset".

We have updated the security file to remove TLS v1 and v1.1 awhile ago.

all of our other connections are working.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 5, 2023, 5:40pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/2 "2023-07-05T17:40:00Z")

</div>

Connection reset might be a firewall issue.

---

<div class="post-metadata">

**Author:** ![Brent\_Osterkamp1](https://avatars.discourse-cdn.com/v4/letter/b/ebca7d/32.png) [@Brent\_Osterkamp1](https://forum.inductiveautomation.com/u/Brent_Osterkamp1)\
**Post date:** [July 5, 2023, 5:58pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/3 "2023-07-05T17:58:58Z")

</div>

Would the firewall issue be on the Ignition gateway or the SQL server VM? you would think it wouldn't be on the Gateway as we already have multiple SQL connections.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 5, 2023, 6:01pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/4 "2023-07-05T18:01:25Z")

</div>

Likely on the other end, given the working connections. Unless the ports differ among them. Are all of the SQL Servers running the same version?

---

<div class="post-metadata">

**Author:** ![Brent\_Osterkamp1](https://avatars.discourse-cdn.com/v4/letter/b/ebca7d/32.png) [@Brent\_Osterkamp1](https://forum.inductiveautomation.com/u/Brent_Osterkamp1)\
**Post date:** [July 5, 2023, 6:03pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/5 "2023-07-05T18:03:30Z")

</div>

No we have one running 8.00.2187 (which is the one not working) and one that is working is version 13.0.6

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 5, 2023, 6:32pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/6 "2023-07-05T18:32:39Z")

</div>

> [@Brent\_Osterkamp1](#):
>
> one running 8.00.2187

Are you sure that old version is supported by the JDBC driver? Did it stop working recently? Or has it ever worked since you updated the TLS settings?

Any chance your firewalls have been updated to block old TLS? (They should, really.)

---

<div class="post-metadata">

**Author:** ![Brent\_Osterkamp1](https://avatars.discourse-cdn.com/v4/letter/b/ebca7d/32.png) [@Brent\_Osterkamp1](https://forum.inductiveautomation.com/u/Brent_Osterkamp1)\
**Post date:** [July 5, 2023, 7:06pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/7 "2023-07-05T19:06:28Z")

</div>

I am trying to double check the VM security file TLS but there is no

> C:\Program Files\Inductive Automation\Ignition\lib\runtime\jre-win\conf\security

Would it be somewhere else?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 5, 2023, 7:07pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/8 "2023-07-05T19:07:42Z")

</div>

Not sure. I rarely deal with Windows. If you upgraded Ignition, the past changes to that security file would have been wiped out.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 5, 2023, 7:23pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/9 "2023-07-05T19:23:53Z")

</div>

There won't be a `lib\runtime\` folder if this is 7.9, as the topic tags suggest. In which case you're at the mercy of your system's installed JVM(s), which likely were updated without your knowledge.

---

<div class="post-metadata">

**Author:** ![Brent\_Osterkamp1](https://avatars.discourse-cdn.com/v4/letter/b/ebca7d/32.png) [@Brent\_Osterkamp1](https://forum.inductiveautomation.com/u/Brent_Osterkamp1)\
**Post date:** [July 5, 2023, 7:31pm UTC](https://forum.inductiveautomation.com/t/database-connection-error-connection-reset/75952/10 "2023-07-05T19:31:38Z")

</div>

Found it, but TLS 1 and 1.1 are already removed
