# MSSQL Integrated Security on Linux Host **URL:** \ **Category:** Ignition\ **Created:** [July 20, 2022, 5:41pm UTC](https://forum.inductiveautomation.com/t/mssql-integrated-security-on-linux-host/62138 "2022-07-20T17:41:02Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![ralacosta](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@ralacosta](https://forum.inductiveautomation.com/u/ralacosta)\ **Post date:** [July 20, 2022, 5:41pm UTC](https://forum.inductiveautomation.com/t/mssql-integrated-security-on-linux-host/62138/1 "2022-07-20T17:41:02Z")
So I’m constantly getting an error in connecting to a MSSQL host using Integrated security. I’ve followed this guide: [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). This guide is for windows though, and I’ve put the auth dll in the ignition directory which should match the Windows one, /usr/local/bin/ignition/lib. I’ve rebooted the service but still get the same error as before, this time though it fails to load the auth dll I’ve placed in the host. org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:4fadc8f2-adc0-404d-90f1-39f3d925feee) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1549) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:261) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:215) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1006) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: This driver is not configured for integrated authentication. ClientConnectionId:4fadc8f2-adc0-404d-90f1-39f3d925feee at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3680) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:74) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4726) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:90) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4715) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7730) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3786) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3233) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2833) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2671) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1640) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:936) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545) … 13 more Caused by: java.lang.UnsatisfiedLinkError: Unable to load authentication DLL mssql-jdbc\_auth-10.2.1.x64 at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:63) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4725) … 26 more 7.9.16 (b2020090709) Oracle Corporation 1.8.0\_191 ---
**Author:** ![ralacosta](https://avatars.discourse-cdn.com/v4/letter/r/f0a364/32.png) [@ralacosta](https://forum.inductiveautomation.com/u/ralacosta)\ **Post date:** [July 20, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/mssql-integrated-security-on-linux-host/62138/3 "2022-07-20T17:48:11Z")
For clarification. The MSSQL DB is on a windows host, and the ignition application is on a linux host. ---
**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:** [July 20, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/mssql-integrated-security-on-linux-host/62138/4 "2022-07-20T17:48:50Z")
You can’t use the integrated security DLL on Linux, but this article seems to imply there’s some way to get a Kerberos ticket on the Linux system that the JDBC driver will use: [Connect using Azure Active Directory authentication - JDBC Driver for SQL Server | Microsoft Docs](https://docs.microsoft.com/en-us/sql/connect/jdbc/connecting-using-azure-active-directory-authentication?view=sql-server-ver16#set-kerberos-ticket-on-windows-linux-and-macos) ---
**Author:** ![declan.mccarthy](https://avatars.discourse-cdn.com/v4/letter/d/dec6dc/32.png) [@declan.mccarthy](https://forum.inductiveautomation.com/u/declan.mccarthy)\ **Post date:** [January 23, 2023, 3:08pm UTC](https://forum.inductiveautomation.com/t/mssql-integrated-security-on-linux-host/62138/5 "2023-01-23T15:08:03Z")
See here [MSSQL Integrated security on Linux Container](https://forum.inductiveautomation.com/t/mssql-integrated-security-from-a-docker-container/64660)