# MSSQL Connection Error "Cannot create PoolableConnectionFactory "

**URL:** <https://forum.inductiveautomation.com/t/mssql-connection-error-cannot-create-poolableconnectionfactory/110600>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [September 13, 2025, 5:42am UTC](https://forum.inductiveautomation.com/t/mssql-connection-error-cannot-create-poolableconnectionfactory/110600 "2025-09-13T05:42:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jchen](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jchen](https://forum.inductiveautomation.com/u/jchen)\
**Post date:** [September 13, 2025, 5:42am UTC](https://forum.inductiveautomation.com/t/mssql-connection-error-cannot-create-poolableconnectionfactory/110600/1 "2025-09-13T05:42:49Z")

</div>

Hi there,

I tried to conenct MSSQL but got an error below:

 ![企业微信截图_17576677445444](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/e/ae2049ae2e9790c4134f290963b9fc3bb7a58363.png)

My ignition version is 8.1.48, SQL server in installed on another server, the MSSQL version is 2022, operation system version is Server 2022.

I updated the MSSQL JDBC driver with the link in the user manual.

[https://github.com/microsoft/mssql-jdbc/releases](https://github.com/microsoft/mssql-jdbc/releases)

Selected the jre11 version and updated the file in the MSSQL driver, not sure if this is the right JDBC file, tried jre8 also get the same error.

 ![企业微信截图_17577417855863](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/2/22c9996bbb78f452e2fc621c77e7b3441f4c06e8.png)

Has anyone encountered the same problem before? I have been able to connect to Microsoft SQL smoothly before, but it seems to be the first time I have encountered the need to update the JDBC driver.

Thanks.

---

<div class="post-metadata">

**Author:** ![David\_Stone](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/david_stone/32/79749_2.png) [@David\_Stone](https://forum.inductiveautomation.com/u/David_Stone)\
**Post date:** [September 13, 2025, 9:07am UTC](https://forum.inductiveautomation.com/t/mssql-connection-error-cannot-create-poolableconnectionfactory/110600/2 "2025-09-13T09:07:07Z")

</div>

That error indicates there is an issue with the SSL connection to MSSQL.  
Is the dns name on the SSL certificate the same as the dns name you are connecting with?

---

<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:** [September 13, 2025, 1:33pm UTC](https://forum.inductiveautomation.com/t/mssql-connection-error-cannot-create-poolableconnectionfactory/110600/3 "2025-09-13T13:33:13Z")

</div>

The server is presenting Ignition with a certificate that is self signed or signed by an authority that java doesn't include by default. Either:

- Add the signing authority to java's trust store, or

- Tell the JDBC driver to trust the server unconditionally. (The option for that is right there in the error message.)

---

<div class="post-metadata">

**Author:** ![jchen](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jchen](https://forum.inductiveautomation.com/u/jchen)\
**Post date:** [September 15, 2025, 6:03am UTC](https://forum.inductiveautomation.com/t/mssql-connection-error-cannot-create-poolableconnectionfactory/110600/4 "2025-09-15T06:03:25Z")

</div>

I don’t have any SSL certificate, just simple connection to SQL server.

---

<div class="post-metadata">

**Author:** ![jchen](https://avatars.discourse-cdn.com/v4/letter/j/3ec8ea/32.png) [@jchen](https://forum.inductiveautomation.com/u/jchen)\
**Post date:** [September 15, 2025, 6:05am UTC](https://forum.inductiveautomation.com/t/mssql-connection-error-cannot-create-poolableconnectionfactory/110600/5 "2025-09-15T06:05:01Z")

</div>

Added “;trustServerCertificate=true“ at Extra Connection Properties has solved the problem, thank you.