# Error when connecting Database connection using MSSQL **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [April 20, 2023, 7:46am UTC](https://forum.inductiveautomation.com/t/error-when-connecting-database-connection-using-mssql/72688 "2023-04-20T07:46:13Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Samir\_Zambare](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Samir\_Zambare](https://forum.inductiveautomation.com/u/Samir_Zambare)\ **Post date:** [April 20, 2023, 7:46am UTC](https://forum.inductiveautomation.com/t/error-when-connecting-database-connection-using-mssql/72688/1 "2023-04-20T07:46:13Z")
java.sql.SQLException: Cannot create PoolableConnectionFactory (Login failed for user ''. ClientConnectionId:bcfbdfb0-9ef8-477f-8b1a-0100475e5100) 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:1096) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:587) 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: Login failed for user ''. ClientConnectionId:bcfbdfb0-9ef8-477f-8b1a-0100475e5100 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217) at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:251) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:81) at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:3080) at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:2361) at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(SQLServerConnection.java:44) at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:2347) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:6276) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1794) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1405) at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1069) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:905) at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:452) at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1014) 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 8.1.25 (b2023021409) Azul Systems, Inc. 11.0.17 ---
**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:** [April 20, 2023, 8:37am UTC](https://forum.inductiveautomation.com/t/error-when-connecting-database-connection-using-mssql/72688/2 "2023-04-20T08:37:18Z")
> [@Samir\_Zambare](#): > > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: **Login failed for user**''. Q1. Have you set up an SQL user account for Ignition to use? Q2. Are you using that account to log in? Q3. Are you providing the correct password. You can search for that error message on the Internet. Here's one answer: > **[com.microsoft.sqlserver.jdbc.sqlserverexception: login failed for user](https://bobcares.com/blog/com-microsoft-sqlserver-jdbc-sqlserverexception-login-failed-for-user/)** > > Take a look at troubleshooting tips to resolve com.microsoft.sqlserver.jdbc.sqlserverexception: login failed for user error. Click here ---
**Author:** ![Samir\_Zambare](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Samir\_Zambare](https://forum.inductiveautomation.com/u/Samir_Zambare)\ **Post date:** [April 20, 2023, 8:53am UTC](https://forum.inductiveautomation.com/t/error-when-connecting-database-connection-using-mssql/72688/3 "2023-04-20T08:53:26Z")
Yes I setup SQL and login with window authentication, also enable TCP/IP ---
**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:** [April 20, 2023, 9:51am UTC](https://forum.inductiveautomation.com/t/error-when-connecting-database-connection-using-mssql/72688/4 "2023-04-20T09:51:48Z")
> [@Samir\_Zambare](#): > > I setup SQL and login with **window authentication** That might be your problem. Ignition may be trying to connect with a different user account. I recommend creating an SQL user account with a password that never expires. Then set Ignition's database connection to use that. Someone wiser may have better ideas. You should tell us if the SQL server is on the gateway or on a different machine. ---
**Author:** ![Samir\_Zambare](https://avatars.discourse-cdn.com/v4/letter/s/839c29/32.png) [@Samir\_Zambare](https://forum.inductiveautomation.com/u/Samir_Zambare)\ **Post date:** [April 20, 2023, 11:47am UTC](https://forum.inductiveautomation.com/t/error-when-connecting-database-connection-using-mssql/72688/5 "2023-04-20T11:47:08Z")
Thank you for information, now it is connected thanks again for information ---
**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:** [April 20, 2023, 3:39pm UTC](https://forum.inductiveautomation.com/t/error-when-connecting-database-connection-using-mssql/72688/6 "2023-04-20T15:39:47Z")
You're welcome. Don't forget to mark one of the answers as the solution.