# SQL Server Connection Faulted

**URL:** <https://forum.inductiveautomation.com/t/sql-server-connection-faulted/46393>\
**Category:** Ignition\
**Tags:** database, ignition79\
**Created:** [May 5, 2021, 6:46pm UTC](https://forum.inductiveautomation.com/t/sql-server-connection-faulted/46393 "2021-05-05T18:46:27Z")\
**Posts on this page:** 1\
**Showing post:** 9

<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:** [June 5, 2021, 2:34pm UTC](https://forum.inductiveautomation.com/t/sql-server-connection-faulted/46393/9 "2021-06-05T14:34:08Z")

</div>

You might need to downgrade. The case I encountered was a SQL Server 2008, which isn’t supported past driver 6.2. See this compatibility chart:

> **[Support matrix - JDBC Driver for SQL Server](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver15)**
>
> This page contains the support matrix and support life-cycle policy for the Microsoft JDBC Driver for SQL Server.

I think with the correct driver, I didn’t need the extra connection properties, just the java.security changes. YMMV, of course.

---

_[View the full topic](https://forum.inductiveautomation.com/t/sql-server-connection-faulted/46393)._
