Getting this error when making a test call.

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host [HOSTNAME] port 1433 has failed.
Error: "[HOSTNAME] Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.

The DBs have said that port 1433 is open and our username/password is correct. The server does not have a static IP, but do I need to do something like add this server to the /etc/host file or /etc/resolv.conf file?

Hi, did you check whether the port for your connection was allowed in the firewall setting ?

Is that different from what the DBs have confirmed with me when they said: "port 1433 is open and your username/password is correct."

There an online post one this error. For errors like this, you could search on the web for solutions.

https://kb.sos-berlin.com/pages/viewpage.action?pageId=17499564

Figured it out. I needed to add the DB in the /etc/hosts file