MSSQL connection not working with Java 17

[Se Ri]

Hi,

I´ve migrated to Java 17 (64 bit) and now I cannot login into my MSSQL connection anymore.

It seems a JAVA issue. I tried it with Java 11 and I was able to connect to the MSSQL database.

Now I got the following exception:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]". ClientConnectionId:983ef684-bdb2-4264-aca4-5dbabcc24832 [SQL State=08S01]

Any idea to fix this?

[Thomas Kellerer]

I don't use SQL Server very often, but as far as I know, newer Microsoft JDBC drivers use encrypted conncections by default.

If your SQL Server is not configured for encrypted connections you need to disable encryption.
I think this should be as simple as appending ;encrypt=false to the JDBC URL

Please consult the manual for the Microsoft JDBC driver for more details.
This is not directly related to SQL Workbench/J

Se Ri schrieb am 03.05.2023 um 08:51:
> Hi,
> I´ve migrated to Java 17 (64 bit) and now I cannot login into my MSSQL connection anymore.
> It seems a JAVA issue. I tried it with Java 11 and I was able to connect to the MSSQL database.
>
> Now I got the following exception:

> /The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]". ClientConnectionId:983ef684-bdb2-4264-aca4-5dbabcc24832 [SQL State=08S01] /

[Se Ri]

Thanks, I´ve commented it out in the java.security file  (in path: jre/conf/security/) and now it´s working...

#jdk.tls.disabledAlgorythmus......

Thanks.

[Chris Young]

I was able to fix this by adding this property to the connection string:

TrustServerCertificate=True;