# Windows Authentication

**URL:** <https://forum.inductiveautomation.com/t/windows-authentication/41363>\
**Category:** General Discussion\
**Created:** [December 9, 2020, 10:44pm UTC](https://forum.inductiveautomation.com/t/windows-authentication/41363 "2020-12-09T22:44:10Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![f1\_beto](https://avatars.discourse-cdn.com/v4/letter/f/e5b9ba/32.png) [@f1\_beto](https://forum.inductiveautomation.com/u/f1_beto)\
**Post date:** [December 9, 2020, 10:44pm UTC](https://forum.inductiveautomation.com/t/windows-authentication/41363/1 "2020-12-09T22:44:10Z")

</div>

hi  
i have problem with Windows Authentication. I copied the file “JDBC Driver for SQL Servers”  
(qljdbc\_auth.dll) in the path C:\Program Files\Inductive Automation\Ignition\lib\ but not work well. i have this error  
“Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication.)”

---

<div class="post-metadata">

**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:** [December 9, 2020, 10:48pm UTC](https://forum.inductiveautomation.com/t/windows-authentication/41363/2 "2020-12-09T22:48:19Z")

</div>

Did you follow all the directions on this page down under “Scenario 2”?

[https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-ConnecttoMicrosoftSQLServer](https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server+Express#ConnectingtoMicrosoftSQLServerExpress-ConnecttoMicrosoftSQLServer)

---

<div class="post-metadata">

**Author:** ![f1\_beto](https://avatars.discourse-cdn.com/v4/letter/f/e5b9ba/32.png) [@f1\_beto](https://forum.inductiveautomation.com/u/f1_beto)\
**Post date:** [December 10, 2020, 6:31pm UTC](https://forum.inductiveautomation.com/t/windows-authentication/41363/3 "2020-12-10T18:31:43Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/4/f441ee7c421a6b4e8b71084bff217e3e5cce9644.png) yes i coped all files, I reset service “ignition” and change the “log On”

---

<div class="post-metadata">

**Author:** ![Tony\_Currie](https://avatars.discourse-cdn.com/v4/letter/t/ea5d25/32.png) [@Tony\_Currie](https://forum.inductiveautomation.com/u/Tony_Currie)\
**Post date:** [May 16, 2022, 2:45pm UTC](https://forum.inductiveautomation.com/t/windows-authentication/41363/4 "2022-05-16T14:45:45Z")

</div>

Hi, I realise this thread is slightly old but i’m having exactly the same issue.  
Were you able to resolve this?

Thanks  
Tony

---

<div class="post-metadata">

**Author:** ![jacque\_trahan](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jacque_trahan/32/58886_2.png) [@jacque\_trahan](https://forum.inductiveautomation.com/u/jacque_trahan)\
**Post date:** [April 18, 2023, 3:52pm UTC](https://forum.inductiveautomation.com/t/windows-authentication/41363/5 "2023-04-18T15:52:12Z")

</div>

I am having a similar issue but with the with _[Scenario 2: Connect By Using Instance Name and Windows Authentication](https://docs.inductiveautomation.com/display/DOC81/Connecting+to+Microsoft+SQL+Server#:~:text=Configuration%20Manager%20at-,Start%20%3E%20All%20Programs%20%3E%20Microsoft%20SQL%20Server%20Version%20%23%20%3E%20Configuration,authentication%2C%20we%20can%20configure%20Ignition.)_ part. Before setting up MSSQL in the gateway. After I put in my credentials when I try to restart I get this error:

> Error 1068: The dependency service or group failed to start.

I have tried all of the following but no luck:

- All the troubleshooting aspects at the bottom of the link above, including option 2 for taking out the [TLS from the java.secruity file](https://support.inductiveautomation.com/hc/en-us/articles/4417310204813-TLS-v1-0-and-v1-1-Microsoft-SQL-Server-Database-connection-issue)
- Added both 1433 and 1434 port to all through the firewall - used chat GPT for this walk through.
- This [Youtube](https://www.youtube.com/watch?v=JeKhquoXTxs) video on Error 1068
- put the DLL zip downloaded file in both directories: **C:\Program Files\Inductive Automation\Ignition\lib** & **C:\Program Files\Inductive Automation\Ignition\user\lib\jdbc**

Has anyone delt with this and if so any advice or points in the right direction would be greatly apricated.
