Database Connection - SQL Server 2017 Express LocalDB

Ignition
1

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
image1218×635 38.8 KB

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

2

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.

1 Like
3

Thanks Jordan, that would explain the issue