Failed to connect to Azure SQL server from android due to TLS version mismatch using jtds connection

Question

Failed to connect to Azure SQL server from android due to TLS version mismatch using jtds connection

Daiya 0

Also tried added ssl=require in connection string it returned error as "Network error IOException: SSL handshake aborted..."

if I added sslProtocol=TLSv1.1 since in Azure server it set as 1.0, but it return message as "Reason:Login failed due to client TLS version being less than server.."

Using jtds.-1.3.1.jar

or what is the right way to set TLS version in connection string?

Daiya 0 Reputation points

2024-07-23T06:28:16.32+00:00

Hi Sir,

after update it return message " No suitable driver found for jdbc:sqlserver:// ..."

val a = StrictMode.ThreadPolicy.Builder().permitAll().build() StrictMode.setThreadPolicy(a) Class.forName("net.sourceforge.jtds.jdbc.Driver")
Daiya 0 Reputation points

2024-07-23T08:52:40.5533333+00:00

Hi Sir,

Appreciate your guide and explanation on this.

Ok I already change the class name to "com.microsoft.sqlserver.jdbc.SQLServerDriver" and updated as below

url= "jdbc"sqlserver://dbServer:dbPort;DatabaseName=dbName; encrypt=true;" con= DriverManager.getConnection(url,dbUser,dbPassword)

and using jar file to sqljdbc42.jar in libs folder.

Message return as "The driver could not establish a secure connection to SQL Server by using Secure Socket Layer SSL encryption. Error: Socket is closed ..... "

Meaning this is not the correct driver too?
SSingh-MSFT 16,371 Reputation points Moderator

2024-07-24T08:20:21.0766667+00:00

Hi Daiya •,

Please check the solutions suggested over this Stackoverflow thread:

https://stackoverflow.com/questions/32766114/sql-server-jdbc-error-on-java-8-the-driver-could-not-establish-a-secure-connect

Let us know if this helped.

Thanks
SSingh-MSFT 16,371 Reputation points Moderator

2024-07-26T04:13:11.0733333+00:00

Hi Daiya •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

2 answers

Your answer

Daiya 0 Reputation points

2024-07-23T06:28:16.32+00:00

Hi Sir,

after update it return message " No suitable driver found for jdbc:sqlserver:// ..."

val a = StrictMode.ThreadPolicy.Builder().permitAll().build() StrictMode.setThreadPolicy(a) Class.forName("net.sourceforge.jtds.jdbc.Driver")
Daiya 0 Reputation points

2024-07-23T08:52:40.5533333+00:00

Hi Sir,

Appreciate your guide and explanation on this.

Ok I already change the class name to "com.microsoft.sqlserver.jdbc.SQLServerDriver" and updated as below

url= "jdbc"sqlserver://dbServer:dbPort;DatabaseName=dbName; encrypt=true;" con= DriverManager.getConnection(url,dbUser,dbPassword)

and using jar file to sqljdbc42.jar in libs folder.

Message return as "The driver could not establish a secure connection to SQL Server by using Secure Socket Layer SSL encryption. Error: Socket is closed ..... "

Meaning this is not the correct driver too?
SSingh-MSFT 16,371 Reputation points Moderator

2024-07-24T08:20:21.0766667+00:00

Hi Daiya •,

Please check the solutions suggested over this Stackoverflow thread:

https://stackoverflow.com/questions/32766114/sql-server-jdbc-error-on-java-8-the-driver-could-not-establish-a-secure-connect

Let us know if this helped.

Thanks
SSingh-MSFT 16,371 Reputation points Moderator

2024-07-26T04:13:11.0733333+00:00

Hi Daiya •,

We haven't heard back from you. In case you already found a solution, would you please share it here with the community? Otherwise, let us know and we will continue to engage with you on the issue.

Thanks

Answer 1

Hi Daiya •,

Check below please:

Difference Drivers If we use JDBC URL format for the jTDS driver, but use sqljdbc4.jar in CLASSPATH, we will wind up with the “No suitable driver found” error for SQL Server Database.
Wrong JDBC Driver Name Including “Microsoft” in JDBC URL for SQL SERVER while using sqljdbc4.jar file to connect to the MSSQL database will result in the error.
Spelling errors in Driver Name Using inaccurate names in the JDBC URL also results in the “No suitable driver found” error.
jTDS vs JDBC Drive Using jTDS driver in the development environment while using the Microsoft JDBC driver (sqljdbc4.jar) in the production environment also causes the error.

Your URL should be jdbc:sqlserver://server:port;DatabaseName=dbname and Class name should be like com.microsoft.sqlserver.jdbc.SQLServerDriver

Please let us know your result.

Thanks.

Answer 2

SSingh-MSFT 16,371 Moderator

Hi Daiya •,

Welcome to Microsoft Q&A forum.

As I understand, you are getting connection failure due to TLS version mismatch using jtds connection.

Please refer to this technical blog https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-357-login-failed-due-to-client-tls-version-being/ba-p/3832318 and follow the steps to get rid of the issue.

Let us know your findings.

Awaiting your reply.

Thanks.

Share via

Failed to connect to Azure SQL server from android due to TLS version mismatch using jtds connection

2 answers

Your answer