# Cannot Create Poolable ConnectionFactory

**URL:** <https://forum.inductiveautomation.com/t/cannot-create-poolable-connectionfactory/108064>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [July 2, 2025, 5:58pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolable-connectionfactory/108064 "2025-07-02T17:58:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mkirisits](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@mkirisits](https://forum.inductiveautomation.com/u/mkirisits)\
**Post date:** [July 2, 2025, 5:58pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolable-connectionfactory/108064/1 "2025-07-02T17:58:00Z")

</div>

I am trying to connect a MSSQL database to a new gateway but keep receiving this fault. We are certain we are using the username/password for connection to the database. We have an older gateway that has been connected to this database.

```python
java.sql.SQLException: Cannot create PoolableConnectionFactory (Login failed for user 'USBL-TS03Service'. ClientConnectionId:cbdabdb1-1d0a-4614-baa5-ad8639dc60ec)
	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: Login failed for user 'USBL-TS03Service'. ClientConnectionId:cbdabdb1-1d0a-4614-baa5-ad8639dc60ec
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:278)
	at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:329)
	at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:137)
	at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:7205)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:5749)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:5681)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7745)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4706)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:4139)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3695)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3504)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:2212)
	at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1320)
	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.44 (b2024102210)
Azul Systems, Inc. 17.0.12

```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 2, 2025, 6:04pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolable-connectionfactory/108064/2 "2025-07-02T18:04:16Z")

</div>

Different JDBC driver versions? Is the working connection on an older, more "relaxed" version?

---

<div class="post-metadata">

**Author:** ![mkirisits](https://avatars.discourse-cdn.com/v4/letter/m/9fc29f/32.png) [@mkirisits](https://forum.inductiveautomation.com/u/mkirisits)\
**Post date:** [July 2, 2025, 6:30pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolable-connectionfactory/108064/3 "2025-07-02T18:30:15Z")

</div>

The older gateway version is 8.1.15 while this new gateway is 8.1.44. Looks like the JDBC for the older gateway is 10.2 while I downloaded the latest for the new gateway (12.10)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 2, 2025, 6:43pm UTC](https://forum.inductiveautomation.com/t/cannot-create-poolable-connectionfactory/108064/4 "2025-07-02T18:43:10Z")

</div>

I don't follow MSSQL stuff closely, but it wouldn't surprise me if the newer driver needs some extra connection parameters to enable a legacy mode of some kind.

Perhaps a support ticket would help. IA has a lot of this stuff indexed.