# Ignition 8.1 Compatibility with SQL Server 2019

**URL:** <https://forum.inductiveautomation.com/t/ignition-8-1-compatibility-with-sql-server-2019/56010>\
**Category:** Ignition\
**Created:** [February 10, 2022, 10:33pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-compatibility-with-sql-server-2019/56010 "2022-02-10T22:33:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brendan\_Murray](https://avatars.discourse-cdn.com/v4/letter/b/bcef8e/32.png) [@Brendan\_Murray](https://forum.inductiveautomation.com/u/Brendan_Murray)\
**Post date:** [February 10, 2022, 10:33pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-compatibility-with-sql-server-2019/56010/1 "2022-02-10T22:33:21Z")

</div>

The documentation states that Ignition is compatible with SQL Server versions up to 2017. Is Ignition 8.1 compatible with SQL Server 2019? There is only one other post about this and the only response was that it was likely compatible. I need a definite answer before a client upgrades their SQL Server version.

Thanks

---

<div class="post-metadata">

**Author:** ![kvane](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kvane/32/22228_2.png) [@kvane](https://forum.inductiveautomation.com/u/kvane)\
**Post date:** [February 10, 2022, 11:13pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-compatibility-with-sql-server-2019/56010/2 "2022-02-10T23:13:32Z")

</div>

Hello,

Yes - Ignition 8.1 is compatible with SQL Server 2019.

The documentation should now be updated for our 8.1 version here:  
[https://docs.inductiveautomation.com/display/DOC81/Database+Connections](https://docs.inductiveautomation.com/display/DOC81/Database+Connections)

---

<div class="post-metadata">

**Author:** ![Brendan\_Murray](https://avatars.discourse-cdn.com/v4/letter/b/bcef8e/32.png) [@Brendan\_Murray](https://forum.inductiveautomation.com/u/Brendan_Murray)\
**Post date:** [February 10, 2022, 11:36pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-compatibility-with-sql-server-2019/56010/3 "2022-02-10T23:36:49Z")

</div>

Thank you

---

<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:** [February 11, 2022, 1:20am UTC](https://forum.inductiveautomation.com/t/ignition-8-1-compatibility-with-sql-server-2019/56010/4 "2022-02-11T01:20:43Z")

</div>

Keep in mind that gateway backups contain prior JDBC drivers, which will overwrite any newer driver in a fresh install. Likely not a problem when upgrading the DB, but you should check your driver if it ever came from an older Ignition install.

---

<div class="post-metadata">

**Author:** ![batkinson](https://avatars.discourse-cdn.com/v4/letter/b/ed8c4c/32.png) [@batkinson](https://forum.inductiveautomation.com/u/batkinson)\
**Post date:** [February 25, 2022, 7:24pm UTC](https://forum.inductiveautomation.com/t/ignition-8-1-compatibility-with-sql-server-2019/56010/5 "2022-02-25T19:24:49Z")

</div>

And if you look at the supported JDBC drivers for SQL Server 2019, it does not technically support the JDBC driver that was in my v8 Ignition (later updated to v8.1). We had to go and download the JDBC driver direct from MS, as the one we had was too old to be supported.