# Database connection with MSSQL

**URL:** <https://forum.inductiveautomation.com/t/database-connection-with-mssql/77835>\
**Category:** General Discussion\
**Tags:** ignition81\
**Created:** [August 14, 2023, 10:35pm UTC](https://forum.inductiveautomation.com/t/database-connection-with-mssql/77835 "2023-08-14T22:35:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![wen.chen](https://avatars.discourse-cdn.com/v4/letter/w/d9b06d/32.png) [@wen.chen](https://forum.inductiveautomation.com/u/wen.chen)\
**Post date:** [August 14, 2023, 10:35pm UTC](https://forum.inductiveautomation.com/t/database-connection-with-mssql/77835/1 "2023-08-14T22:35:36Z")

</div>

I am trying to set up Ignition database connection with MSSQL. However, I kept getting this communication error message below after I checked my firewall, enabled TCP/IP setting on the SQLEXPRESS I set up...etc.  
_Cannot create PoolableConnectionFactory (The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".)_

I am not sure if this issue can come from drivers being outdated or not, but just to provide more background on my environment. I am using Windows 11, Ignition 8.1.28, and SSMS 19.1.

I would appreciate a word of advice on at least where to start looking to fix this error. Thanks.

---

<div class="post-metadata">

**Author:** ![aaronrai24](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/aaronrai24/32/87248_2.png) [@aaronrai24](https://forum.inductiveautomation.com/u/aaronrai24)\
**Post date:** [August 14, 2023, 11:30pm UTC](https://forum.inductiveautomation.com/t/database-connection-with-mssql/77835/2 "2023-08-14T23:30:02Z")

</div>

First double check TCP/IP are still enabled for protocols for SQLEXPRESS(you need to restart the service after setting this also). I've noticed that sometimes you have to be an administrator to fully enable TCP/IP. I'd also verify SQL server browser is running, this can all be done in the SQL Server Configuration Manager. Is this database local to the Ignition gateway or on another system?

---

<div class="post-metadata">

**Author:** ![wen.chen](https://avatars.discourse-cdn.com/v4/letter/w/d9b06d/32.png) [@wen.chen](https://forum.inductiveautomation.com/u/wen.chen)\
**Post date:** [August 15, 2023, 4:17pm UTC](https://forum.inductiveautomation.com/t/database-connection-with-mssql/77835/3 "2023-08-15T16:17:01Z")

</div>

It's a local database. I will enable TCP/IP as an administrator then see if my Ignition gateway can see it.

---

<div class="post-metadata">

**Author:** ![drojas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drojas/32/3403_2.png) [@drojas](https://forum.inductiveautomation.com/u/drojas)\
**Post date:** [August 15, 2023, 5:54pm UTC](https://forum.inductiveautomation.com/t/database-connection-with-mssql/77835/4 "2023-08-15T17:54:44Z")

</div>

> [@aaronrai24](#):
>
> I'd also verify SQL server browser is running

This is the way.