So I have a SQL Server 2012 DB running with a ODBC connection. When I try to set up the datasource in the Lucee web admin, it says that port 1433 might be block by the firewall. The issue is that port 1433 is open for incoming and outgoing connections. Also the TCP/IP connection is also open (telnet pings port 1433 with no issues). Any idea what might be going on? We are switching from Railo to Lucee (this is a very old internal system we are using) and in Railo we are using JDBC-ODBC Bridge (which I see Lucee doesn’t have).
Any help would be greatly appreciated.