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.
https://www.mssqltips.com/sqlservertip/5612/getting-started-with-sql-server-2017-express-localdb/