The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.

[medwards8]

Driver version

mssql-jdbc-10.2.0.jre8

SQL Server version

Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - 15.0.2080.9 (X64) Nov 6 2020 16:50:01 Copyright (C) 2019 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 (Build 19042: ) (Hypervisor)

Client Operating System

Windows 10 Enterprise 10.0

JAVA/JVM version

Error I'm currently getting:

Content of config file it is referencing:

Doing this same process on 8.5.1 it runs perfectly fine, only get this error on 8.5.4. I have tried:

-Updating java version
-adding trustServerCertificate=true
-specifying username/password
-sslProtocol=TLSv1/v1.2

Produces same error every time.

[VeryVerySpicy]

Hi @medwards8 ,
Thanks for reaching out to us. We will take a look soon.

As a quick check, can you add trustServerCertificate=true to your connection string and try again?

[medwards8]

Hi @v-zhangw thanks that seems to work now. Strange I'm sure I tried adding that in, I must have done some other configuring in the meantime

[VeryVerySpicy]

No problem. The unable to find valid certification path error usually means an issue with certificates set up. Using trustservercertificate is a quick fix if you can use it.