# 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:** 11\ **Page:** 2
**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 7, 2023, 10:31pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/21 "2023-11-07T22:31:10Z")
What is the exact error (full stack trace) you get? Does that DLL match the JDBC driver version you have installed? ---
**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, 11:39pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/22 "2023-11-07T23:39:27Z")
Hi Kevin, Error on Status -\> CONNECTIONS -\> Databases -\> Details: > Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:0cdd34c6-5fc2-4c53-a879-c126acb8fd26) I'm not exactly sure how to get the full stack trace - Diagnostics -\> Logs? In my `C:\Program Files\Inductive Automation\Ignition\user-lib\jdbc` folder, I have > mssql-jdbc-7.2.1.jre11.jar and a > mssql-jdbc-9.2.1.jre11.jar So I guess I should have downloaded a different driver? Like the 9.2.1 driver? Trying now. ---
**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, 11:50pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/23 "2023-11-07T23:50:10Z")
Wait no, my Ignition gateway version is 8.1.28 which the documentation says runs java 11 which the 12.4 driver should be good with as far as I can tell. ---
**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:** [November 8, 2023, 12:09am UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/24 "2023-11-08T00:09:46Z")
> [@dion.botha](#): > > `jdbc` folder, I have There must be only **one** jar for a particular DB brand. (Ending up with two usually means a failed JDBC install at some point.) Delete one and restart your gateway. Then install the jar that matches the DLL you want. Check back that you didn't strand another old jar. ---
**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 9, 2023, 4:11pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/25 "2023-11-09T16:11:25Z")
Thanks Phil, ok, so I deleted the older `mssql-jdbc-7.2.1.jre11.jar` and restarted the gateway. I then decided that I would update our Ignition systems from 8.1.28 to current 8.1.33 as the documentation indicates that java version recently changed from 11 to 17 and I thought I may as well while I am here. My gateway now says it is running java version 17.0.8+7-LTS, I have the `mssql-jdbc_auth-12.4.2.x64.dll` file in the `lib` folder. I also have `mssql-jdbc-9.2.1.jre11.jar` in the jdbc folder with no other jar files for the db brand - shouldn't there now be a jre17.jar in there now? Still getting the same error... ---
**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 9, 2023, 4:18pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/26 "2023-11-09T16:18:04Z")
I'm wondering if maybe I should try upgrading the JDBC driver from `mssql-jdbc-9.2.1.jre11.jar` to `mssql-jdbc-12.4.2.jre11.jar` as described here: > [JDBC Drivers and Translators - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators) ---
**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Post date:** [November 9, 2023, 4:22pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/27 "2023-11-09T16:22:27Z")
Consider taking a look at the SQL Server JDBC Driver support matrix: [https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16](https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16) I don't think it is a bad idea to go to the latest supported JDBC driver if possible. You should also be able to use the `.jre17` variants with 8.1.33+. EDIT: after taking a peek at the latest (at time of writing) 12.4 version, it looks like they've not done a build that is leveraging JDK17 features, so the `.jre11` variant is still the latest choice. 👍 ---
**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Post date:** [November 9, 2023, 4:32pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/28 "2023-11-09T16:32:34Z")
> [@dion.botha](#): > > I have the `mssql-jdbc_auth-12.4.2.x64.dll` file in the `lib` folder. I also have `mssql-jdbc-9.2.1.jre11.jar` in the jdbc folder with no other jar files for the db brand - shouldn't there now be a jre17.jar in there now? One thing I'll mention is that we leave your JDBC drivers in place on upgrade. Also, the native DLL for auth needs to match the JDBC driver version. So you're on the right path with your proposal to match up the JDBC JAR to `mssql-jdbc-12.4.2.jre11.jar`. ---
**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 9, 2023, 8:03pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/29 "2023-11-09T20:03:36Z")
If I try to upgrade JDBC driver and things go south how would I restore to previous? Would a gateway restore from backup get me back? ---
**Author:** ![TMAR](https://avatars.discourse-cdn.com/v4/letter/t/e36b37/32.png) [@TMAR](https://forum.inductiveautomation.com/u/TMAR)\ **Post date:** [November 13, 2023, 2:30pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/30 "2023-11-13T14:30:58Z")
Thanks! ---
**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:** [November 13, 2023, 2:52pm UTC](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869/31 "2023-11-13T14:52:46Z")
_ **Pssst!** _ If you reply via email, delete the signatures, images, legal notices, and quoted material that you would normally get, to comply with this forum's neatness [rules](https://forum.inductiveautomation.com/faq). You should edit the above comment accordingly. (If you can't get your emails to conform for any reason, don't use email replies **at all**.) [Previous page](https://forum.inductiveautomation.com/t/java-sql-sqlexception-cannot-create-poolableconnectionfactory-this-driver-is-not-configured-for-integrated-authentication/62869.md?page=1)