How to disable SQL Server JDBC SSL Encryption (in 10.2 driver version and onwards)

Question

Since 10.2, SQL Server enables SSL by default, which is a breaking change by their own admission:

https://learn.microsoft.com/en-us/sql/connect/jdbc/release-notes-for-the-jdbc-driver?view=sql-server-ver16#changes-in-102

Now, the question is how to adapt an existing, good/working JDBC connection string to not use encryption. E.g. what should this URL become?

jdbc:sqlserver://localhost:1433;databaseName=SomeDatabase;

Answer 1

Seems to be just add encrypt=false; to the end, and the app starts up again.

Answer 2

Important to know: encrypt=false does NOT disable encryption, it just indicates that it's not required by the client. If it's set to false, and the server requires encryption, then the connection will be encrypted, but the server certificate will not be verified.