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.