# Faulted Connection for MSSQL **URL:** \ **Category:** Ignition\ **Tags:** database\ **Created:** [July 5, 2025, 5:07am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152 "2025-07-05T05:07:16Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 5:07am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/1 "2025-07-05T05:07:16Z")
Hi, I am trying to create a new database connection for Microsoft SQL Server. In SQL Server Management Studio I have Windows Authentication Mode. While creating a database connection in ignition i am leaving username field blank. Also i have copied the "mssql-jdbc\_auth-12.10.1.x64.dll" to my ignition directory. But still the connection is showing as Faulted. What am i doing wrong? ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 5:51am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/2 "2025-07-05T05:51:47Z")
Could you provide the error you are getting? Now it's guess work for everyone. ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 6:00am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/3 "2025-07-05T06:00:40Z")
java.sql.SQLException: Cannot create PoolableConnectionFactory (This driver is not configured for integrated authentication. ClientConnectionId:04e621a2-1c2e-49cb-aeed-95002525458c) 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:1097) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:593) 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:04e621a2-1c2e-49cb-aeed-95002525458c at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:3422) at com.microsoft.sqlserver.jdbc.AuthenticationJNI.(AuthenticationJNI.java:72) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:4238) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:4227) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3488) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:2978) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:2628) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:2471) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1470) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:915) 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.4.0.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:4237) ... 24 more 8.1.48 (b2025042910) Azul Systems, Inc. 17.0.14 ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 6:08am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/4 "2025-07-05T06:08:04Z")
Can you share the connection string parameters. The integratedSecurity parameter is required to make it work. jdbc:sqlserver://sqlserver-hostnaam:1433;databaseName=IgnitionDB;integratedSecurity=true The gateway must run on a windows account, under which account does it run? Do you use Windows or Linux as the OS? ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 6:38am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/5 "2025-07-05T06:38:55Z")
jdbc:sqlserver://localhost\SQLEXPRESS i use windows. there is only 1 account 'Administrator' ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 6:45am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/6 "2025-07-05T06:45:01Z")
By default ignition will run as a LocalAccount without any privileges, it basically runs as anonymous. The Service must be configured to run as a specific user, the SQL server must also be able to identify that account. Using windows Active Directory you can achieve this using multiple servers (one for Ignition, one for SQL) Using a single machine you can use local accounts. ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 6:47am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/7 "2025-07-05T06:47:15Z")
I am using local accounts for both sql and ignition ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/6/76cee9cfb751588376e396972f686d14d7d46b9a.png) IS THIS CORRECT? ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 6:50am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/8 "2025-07-05T06:50:56Z")
That looks as expected. Can you show the details of the service in Windows services? There is a tab for the account it is running under. ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 6:57am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/9 "2025-07-05T06:57:29Z")
for ignition ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/4/245a259dd9fba86ee1522f08e497f1c77307ce9c.png) for mssql ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/c/ac901c51ca256fb554d5708b08b5e8b459f1d95c.png) ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 7:16am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/10 "2025-07-05T07:16:11Z")
Ok, Create a new local account next tot the administrator (Never use an admin account). And let the ignition server run as that new user. In SQL you can grant the new user the privileges to connect and interact withe the Database. ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 7:40am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/11 "2025-07-05T07:40:42Z")
Ignition ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/9/8939618cf015df89683b8efd64002281bdb4ba51.png) for sql ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/f/bfd6e1bb9f3e5d7031eabaf6538d8a64ad459270.png) I have given the user full control of Ignition Folder ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/0/f09cada10ee8a6c0ead6e94455401fd754eba6ff.png) Still showing faulted connection ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 8:02am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/12 "2025-07-05T08:02:06Z")
I did not mention the SQL server account, that must runder under local system account. Did you restart the gateway? This is required when changing the account under which is runs. In MSSQL did you add the account? And give him the privileges to select a database? ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 8:26am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/13 "2025-07-05T08:26:05Z")
user account permission in sql ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/0/c0d8a51fe0b79315df4883bde21ec4f9785d0325.png) ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 8:29am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/14 "2025-07-05T08:29:59Z")
That part looks promising. But did you restart the gateway after you changed the running account? Can you show the general tab in SQL where the account is defined? It shows the authentication mode. ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 8:33am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/15 "2025-07-05T08:33:30Z")
I restarted the gateway as well as sqlexpress service. where can i see the account definition? ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 8:35am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/16 "2025-07-05T08:35:47Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/6/4671e326dcfd0ef64d5134c4404edf1482aa1017.png) ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 8:58am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/17 "2025-07-05T08:58:31Z")
Resolved...The connection is showing Valid jdbc:sqlserver://localhost\SQLEXPRESS;databaseName=DATABASE\_1;integratedSecurity=true;encrypt=true;trustServerCertificate=true ---
**Author:** ![Rick\_de\_Man](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/rick_de_man/32/75670_2.png) [@Rick\_de\_Man](https://forum.inductiveautomation.com/u/Rick_de_Man)\ **Post date:** [July 5, 2025, 9:48am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/18 "2025-07-05T09:48:59Z")
Great notice, I forgot to mention that one. Is used when using certificates. ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [July 5, 2025, 10:03am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/19 "2025-07-05T10:03:55Z")
A random recollection from the back of my head somewhere is that you can omit the `databaseName` parameter to enable connection to _any_ database accessible to that server. As you've configured it you'd need a separate connection to connect to another DB. Omitting the `databaseName` parameter _does_ mean that you'd have to specify it in your queries. This might all be nonsense! _I'm getting forgetful. Did I tell you that already?_ ---
**Author:** ![gauravavhad.1989](https://avatars.discourse-cdn.com/v4/letter/g/e5b9ba/32.png) [@gauravavhad.1989](https://forum.inductiveautomation.com/u/gauravavhad.1989)\ **Post date:** [July 5, 2025, 10:13am UTC](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152/20 "2025-07-05T10:13:04Z")
will connecting to master db and then mentioning the required dbname in the query help? [Next page](https://forum.inductiveautomation.com/t/faulted-connection-for-mssql/108152.md?page=2)