# SQL Server Database Connection with Integrated Security

**URL:** <https://forum.inductiveautomation.com/t/sql-server-database-connection-with-integrated-security/2703>\
**Category:** Ignition\
**Created:** [March 1, 2011, 2:14am UTC](https://forum.inductiveautomation.com/t/sql-server-database-connection-with-integrated-security/2703 "2011-03-01T02:14:40Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![reed.hoffmaster](https://avatars.discourse-cdn.com/v4/letter/r/ad7895/32.png) [@reed.hoffmaster](https://forum.inductiveautomation.com/u/reed.hoffmaster)\
**Post date:** [December 12, 2022, 7:43pm UTC](https://forum.inductiveautomation.com/t/sql-server-database-connection-with-integrated-security/2703/5 "2022-12-12T19:43:38Z")

</div>

I was having trouble connecting with Windows Authentication as well. I found that I was getting a similar error from the Gateway Status page...

`Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.`

I noticed further down in the stack trace however, that the driver version Ignition was looking for did not match the latest version I downloaded (per the User Manual Guide: [Connecting to Microsoft SQL Server](https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server), Scenario 2: Connect By Using Instance Name and Windows Authentication)

`java.lang.UnsatisfiedLinkError: no mssql-jdbc_auth-9.4.0.x64 in java.library.path: [lib, lib\core\gateway]`

I sought out, and downloaded the mssql-jdbc\_auth-X.X.X.x64.dll file that matched the mssql-jdbc-9.4.0.jre11.jar file located in _C:\Program Files\Inductive Automation\Ignition\user-lib\jdbc_, which was 9.4.0 in my case. I put that file in the location described by the connection guide and my connection worked.

TL;DR, The connection guide should be updated to specify that the DLL file you want should match the mssql-jdbc JAR file in your user-lib/jdbc directory, instead of just "...it's recommended you use the most recent driver available for your system".

Specs: Ignition 8.1.21, Running on Windows Server 2019.

---

_[View the full topic](https://forum.inductiveautomation.com/t/sql-server-database-connection-with-integrated-security/2703)._