# java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication **URL:** \ **Category:** Ignition\ **Created:** [August 10, 2022, 12:15pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869 "2022-08-10T12:15:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![kwabena\_hobbs](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@kwabena\_hobbs](https://forum.inductiveautomation.com/u/kwabena_hobbs)\ **Post date:** [August 10, 2022, 12:15pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/1 "2022-08-10T12:15:31Z")
Hello All, I I have two of my Microsoft JDBC connections faulting after upgrading from Ignition 8.1.7 to 8.1.19. There were working fine before the upgrade. Anyone run into the issue before? java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:bf4d3ad6-a9f3-4c61-8708-b87adc557c9f) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:656) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:300) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:253) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1096) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:587) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:bf4d3ad6-a9f3-4c61-8708-b87adc557c9f at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3206) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:72) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4015) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4004) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2768) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2418) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2265) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1291) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:881) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:103) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:652) … 12 more Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc\_auth-9.2.1.x64 in java.library.path: [lib, lib\core\gateway] at java.base/java.lang.ClassLoader.loadLibrary(Unknown Source) at java.base/java.lang.Runtime.loadLibrary0(Unknown Source) at java.base/java.lang.System.loadLibrary(Unknown Source) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:51) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4014) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(SQLServerConnection.java:85) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4004) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7418) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3272) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2768) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2418) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2265) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1291) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:881) at org.apache.commons.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:103) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:652) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:300) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.getConnectionImpl(DatasourceManagerImpl.java:169) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnection(DatasourceImpl.java:293) at com.inductiveautomation.ignition.gateway.tags.actors.factories.value.db.DBTagActorFactory$DBTagActor.getConnection(DBTagActorFactory.java:277) at com.inductiveautomation.ignition.gateway.tags.actors.factories.value.db.DBTagActorFactory$DBTagActor.runInternal(DBTagActorFactory.java:226) at com.inductiveautomation.ignition.gateway.tags.actors.factories.value.AbstractExpressionActor.run(AbstractExpressionActor.java:145) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.run(Unknown Source) … 4 more 8.1.19 (b2022072711) Azul Systems, Inc. 11.0.15 ---
**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:** [August 10, 2022, 12:25pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/2 "2022-08-10T12:25:20Z")
Integrated auth was deliberately disabled due to a security hole recently found in Microsoft’s stack. Not yet plugged. There’s a way to enable it anyways, IIRC, but I don’t have the link to a forum topic handy. ---
**Author:** ![kwabena\_hobbs](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@kwabena\_hobbs](https://forum.inductiveautomation.com/u/kwabena_hobbs)\ **Post date:** [August 10, 2022, 12:29pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/3 "2022-08-10T12:29:03Z")
Thanks for the quick response. So is there a way to reconfigure the database connection and not use integrated authentication? ---
**Author:** ![kwabena\_hobbs](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@kwabena\_hobbs](https://forum.inductiveautomation.com/u/kwabena_hobbs)\ **Post date:** [August 10, 2022, 12:36pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/4 "2022-08-10T12:36:28Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/a/daafa1b5d112fadc878c18d417e80344674a7fcc.png) ---
**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:** [August 10, 2022, 12:41pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/5 "2022-08-10T12:41:30Z")
Most of my clients use database user accounts instead of integrated security. You’ll need to set that up in the DB, then turn off integrated security. ---
**Author:** ![kwabena\_hobbs](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@kwabena\_hobbs](https://forum.inductiveautomation.com/u/kwabena_hobbs)\ **Post date:** [August 10, 2022, 12:43pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/6 "2022-08-10T12:43:14Z")
I’ll give that a try, thanks for your help! ---
**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:** [August 10, 2022, 12:53pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/7 "2022-08-10T12:53:57Z")
You mixing this up with the AD SSO thing? ---
**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:** [August 10, 2022, 12:56pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/8 "2022-08-10T12:56:16Z")
Oooo! Maybe. /: ---
**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:** [August 10, 2022, 12:58pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/9 "2022-08-10T12:58:29Z")
> [@kwabena\_hobbs](#): > > Caused by: java.lang.UnsatisfiedLinkError: no mssql-jdbc\_auth-9.2.1.x64 in java.library.path: [lib, lib\core\gateway] @kwabena_hobbs this seems to be your underlying issue. ---
**Author:** ![kwabena\_hobbs](https://avatars.discourse-cdn.com/v4/letter/k/c67d28/32.png) [@kwabena\_hobbs](https://forum.inductiveautomation.com/u/kwabena_hobbs)\ **Post date:** [August 10, 2022, 1:22pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/10 "2022-08-10T13:22:27Z")
I tried copying the file to the gateway directory. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/7/c7cddd697abc279d7940b8a7a48cb620323db74b.png) ---
**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:** [August 10, 2022, 1:24pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/11 "2022-08-10T13:24:34Z")
Kind of looks like you have an extra space after “x64” in that filename. You also have some file name extensions hidden… make sure the filename is correct. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [November 1, 2022, 3:39pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/12 "2022-11-01T15:39:59Z")
Did you ever resolve this? I just did a fresh install of 8.1.19. Ran into the same error you had. Downloaded the `mssql-jbdc_auth-9.2.1.x64.dll` from microsoft's webiste, put it in the folder, restarted my Ignition service but I am still get the `This driver is not configured for integrated authentication` error. Edit: It was my fault. I needed 9.4.0 ---
**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 1, 2022, 3:57pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/13 "2022-11-01T15:57:22Z")
Post the full stack trace you're getting. You may also need to make sure the JDBC driver version and DLL version match up. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [November 1, 2022, 4:03pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/14 "2022-11-01T16:03:25Z")
Yea was my own fault. I searched for the error, found this thread and assumed I too needed 9.2.1. Looking at the full error stack I actually needed `msssql-jbdc_auth-9.4.0.x64.dll`. Downloading that and putting it under lib/core/Gateway has solved my issue. ---
**Author:** ![James\_Dancalan](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@James\_Dancalan](https://forum.inductiveautomation.com/u/James_Dancalan)\ **Post date:** [February 6, 2023, 1:18am UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/15 "2023-02-06T01:18:05Z")
My issue resolved by this guide. ---
**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\ **Post date:** [February 6, 2023, 1:43am UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/16 "2023-02-06T01:43:16Z")
> [@James\_Dancalan](#): > > by this guide I don't see the guide. Is the link missing? ---
**Author:** ![James\_Dancalan](https://avatars.discourse-cdn.com/v4/letter/j/22d042/32.png) [@James\_Dancalan](https://forum.inductiveautomation.com/u/James_Dancalan)\ **Post date:** [February 6, 2023, 1:54am UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/17 "2023-02-06T01:54:45Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/6/f61a562d2002a03b3e06ac86c630aebcb5150065.png) you need to copy the mssql-jdbc\_auth to C:\Program Files\Inductive Automation\Ignition\lib\core\gateway. The .dll file it depends the version of your jdbc driver. ---
**Author:** ![TMAR](https://avatars.discourse-cdn.com/v4/letter/t/e36b37/32.png) [@TMAR](https://forum.inductiveautomation.com/u/TMAR)\ **Post date:** [June 30, 2023, 3:21pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/18 "2023-06-30T15:21:51Z")
Where do you copy it from? ---
**Author:** ![James\_Caudle](https://avatars.discourse-cdn.com/v4/letter/j/5f9b8f/32.png) [@James\_Caudle](https://forum.inductiveautomation.com/u/James_Caudle)\ **Post date:** [November 3, 2023, 5:29pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/19 "2023-11-03T17:29:36Z")
Did you ever get this answered? Its in the repo zip file. ([Connecting to Microsoft SQL Server - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server)) [Releases · microsoft/mssql-jdbc (github.com)](https://github.com/microsoft/mssql-jdbc/releases) ---
**Author:** ![dion.botha](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@dion.botha](https://forum.inductiveautomation.com/u/dion.botha)\ **Post date:** [November 7, 2023, 10:14pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/20 "2023-11-07T22:14:42Z")
Hi All, I am trying to connect to a db via windows authentication getting the error and have tried copying the 'mssql-jdbc\_auth-12.4.2.x64.dll' file over into each of the following folders without success: - C:\Program Files\Inductive Automation\Ignition\lib\ (this is what the Ignition docs say to put it) - C:\Program Files\Inductive Automation\Ignition\lib\core\gateway (this is where some people here say to put it) - C:\Windows\System32 (this is where another post suggested to put it) I have restarted the Ignition service after each of these attempts too... I have verified that I can connect to these databases with the same credentials using SSMS. Any ideas? [Next page](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869.md?page=2)