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.