# RESOLVED - MSSQL Server 2019 Connection Fails - This driver is not configured for integrated authentication **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [February 16, 2022, 3:08pm UTC](https://forum.inductiveautomation.com/t/resolved-mssql-server-2019-connection-fails-this-driver-is-not-configured-for-integrated-authentication/56211 "2022-02-16T15:08:07Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Markus\_Egger](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Markus\_Egger](https://forum.inductiveautomation.com/u/Markus_Egger)\ **Post date:** [February 16, 2022, 3:08pm UTC](https://forum.inductiveautomation.com/t/resolved-mssql-server-2019-connection-fails-this-driver-is-not-configured-for-integrated-authentication/56211/1 "2022-02-16T15:08:07Z")
Ignition Version: **8.1.14** Followed the instructions according linke below Scenario 2 [https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server](https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server) But still get faulted connection to the MSSQL Server Any tips? Thanks! ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [February 16, 2022, 5:15pm UTC](https://forum.inductiveautomation.com/t/resolved-mssql-server-2019-connection-fails-this-driver-is-not-configured-for-integrated-authentication/56211/2 "2022-02-16T17:15:18Z")
Did you happen to see this thread? > [@SQL Server Database Connection with Integrated Security](https://forum.inductiveautomation.com/t/sql-server-database-connection-with-integrated-security/2703/3): > > I have Ignition 8.1.11. Followed instructions in [https://support.inductiveautomation.com/hc/en-us/articles/360047131512-Microsoft-SQL-Server-MSSQL-Connection-Guide-for-Ignition](https://support.inductiveautomation.com/hc/en-us/articles/360047131512-Microsoft-SQL-Server-MSSQL-Connection-Guide-for-Ignition). Had issue. But fixed it. If I followed default instructions I had an error 1(fig 1 File Missing). I have some hard time to figure out what i can do… After i had an idea just not to rename file as they telling in the instruction → Had another issue (fig 2 File missing). Then i just keep 2 files (1 renamed and 1 not) … ---
**Author:** ![y.parashchuk](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/y.parashchuk/32/37781_2.png) [@y.parashchuk](https://forum.inductiveautomation.com/u/y.parashchuk)\ **Post date:** [February 16, 2022, 5:57pm UTC](https://forum.inductiveautomation.com/t/resolved-mssql-server-2019-connection-fails-this-driver-is-not-configured-for-integrated-authentication/56211/3 "2022-02-16T17:57:45Z")
I had an issues with Integrated security. 1. I played with some new JDBC versions like 10+ - it not worked. 9.4.0 is working correctly. 2. The problem is that JDBC is referencing itself somehow, so it looking for file with the name mssql-jdbc\_auth-9.4.0.x64. So all what i did to solve the issue which i had - copied JBDC file - named it as ignition document want. And then placed the same file but didn’t renamed it. So i have 2 same files but with different names. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/e/2ec4792a4fcd0f42305fe1a3403f6145e7623c6c.png) ---
**Author:** ![Markus\_Egger](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@Markus\_Egger](https://forum.inductiveautomation.com/u/Markus_Egger)\ **Post date:** [February 16, 2022, 7:20pm UTC](https://forum.inductiveautomation.com/t/resolved-mssql-server-2019-connection-fails-this-driver-is-not-configured-for-integrated-authentication/56211/4 "2022-02-16T19:20:10Z")
@JordanCClark @y.parashchuk Thanks, I now used also the 2 files one renamed and the other not renamed but had also to copy the unrenamed file into the lib/core/gateway folder but then it worked! Thanks a lot for the tips! 👍 ---
**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:52pm UTC](https://forum.inductiveautomation.com/t/resolved-mssql-server-2019-connection-fails-this-driver-is-not-configured-for-integrated-authentication/56211/5 "2022-12-12T19:52:27Z")
I also found that the filename that Ignition was looking for was not correct. My solution only requires the 9.4.0 file to be placed in the lib directory, and not the sqljdbc\_auth.dll file. > [@SQL Server Database Connection with Integrated Security](https://forum.inductiveautomation.com/t/sql-server-database-connection-with-integrated-security/2703/5): > > 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…