# Database Connection - SQL Server 2017 Express LocalDB

**URL:** <https://forum.inductiveautomation.com/t/database-connection-sql-server-2017-express-localdb/31904>\
**Category:** Ignition\
**Created:** [February 4, 2020, 1:52pm UTC](https://forum.inductiveautomation.com/t/database-connection-sql-server-2017-express-localdb/31904 "2020-02-04T13:52:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlopez](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jlopez](https://forum.inductiveautomation.com/u/jlopez)\
**Post date:** [February 4, 2020, 1:52pm UTC](https://forum.inductiveautomation.com/t/database-connection-sql-server-2017-express-localdb/31904/1 "2020-02-04T13:52:57Z")

</div>

I am trying to setup a new database connection for development purposes to keep separate from production. I want to connect to SQL Server _ **LocalDB** _ Instance on my local machine with Ignition Gateway residing on server, but I’ve been unsuccessful in setting this up. I have allowed outbound/inbound traffic on the firewall for port 1433 and can ping my machine from the server and vice versa.

I have had no problem connecting to MySQL and SQL Server databases on other machines, maybe its an issue with LocalDB lightweight version of SQL Server?

Any help would be appreciated.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/7bfcb7ec0ff87aaa449bd5e6347cc20bc014ab08.png)

[https://www.mssqltips.com/sqlservertip/5612/getting-started-with-sql-server-2017-express-localdb/](https://www.mssqltips.com/sqlservertip/5612/getting-started-with-sql-server-2017-express-localdb/)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 4, 2020, 2:54pm UTC](https://forum.inductiveautomation.com/t/database-connection-sql-server-2017-express-localdb/31904/2 "2020-02-04T14:54:51Z")

</div>

LocalDB does not accept TCP/IP connections which is what Ignition needs to use, even if it’s on the same computer. Use the standard version of Express.

---

<div class="post-metadata">

**Author:** ![jlopez](https://avatars.discourse-cdn.com/v4/letter/j/aeb1de/32.png) [@jlopez](https://forum.inductiveautomation.com/u/jlopez)\
**Post date:** [February 5, 2020, 1:59pm UTC](https://forum.inductiveautomation.com/t/database-connection-sql-server-2017-express-localdb/31904/3 "2020-02-05T13:59:31Z")

</div>

Thanks Jordan, that would explain the issue