Is there anyway to connect to Azure SQL Server using jTDS with TLS 1.2?

Question

Our Java app use jTDS 1.3.1 to connect to SQL Server, which works fine until a client trying to put the database on Azure SQL. The connection failed with the following exception:

java.sql.SQLException: Reason: Login failed due to client TLS version being less than minimal TLS version allowed by the server.

I checked the documentation of jTDS, can't see anyway to specify TLS version. Besides replacing it with MS JDBC driver, has anyone succeeded with other work around?

I don't have access to Azure SQL so cannot test if reducing the TLS version to 1.0 would work.

Thanks.

Answer 1

Solved the issue by chance. Just need to append ";ssl=request" to the connection string. It looks like by default SSL/TLS is disabled. The error message about TLS version is misleading. Hope this help someone in the future.