I just updated to 138.1400.3 to test the SQL Server Windows Auth functionality since it didn't work in the previous release. It doesn't seem to be working for me in this latest version. I keep getting error 08s01 "The TCP/IP connection to the host has failed." I have tried entering in the host as both SERVERNAME and SERVERNAME\INSTANCENAME. I can connect to the server using SQL Server Mgmt Studio without issue. We are not running any firewalls on our computer that could also potentially block the application from communicating with the server. In the Driver Files section, it lists I'm using the SQL Server/Microsoft driver files. It prompted earlier to install a driver update and it appeared to install successfully. I tried using jTds but it did not have a checkbox for Windows Auth so I continued to use the MS driver.
This is the full error message:
Connection to SQL Server - @SERVER\INSTANCE failed
java.sql.SQLException: The TCP/IP connection to the host SERVER, port 1433 has failed. Error: "connect timed out. 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.".