CODEWITHSUNDEEP
sql-serverjdbc
Dave Ankin
Dave Ankin

Reputation: 1291

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

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;

Upvotes: 19

Views: 24229

Answers (1)

Dave Ankin
Dave Ankin

Reputation: 1291

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

Upvotes: 22

Related Questions