DBeaver:- Error Message – Driver file download failed due to a certificate issue – Try changing the setting `Use Windows trust store`

Daniel Adeniji DBeaver, Microsoft, SQL Server ( Microsoft ), SSL ( Technical ), Technical, v24.0.2 ( DBeaver – Version ), , , ,

Background

Early this weekend, I was having problems with Microsoft SQL Server.

There was a perplexing error, I just couldn’t get around around.

Adding to my bruise, SQL Server Management Studio ( SSMS ) was a bit in my way.

I installed a fresh copy of DBeaver.

With a fresh copy of DBeaver, I needed to download a corresponding driver for my targeted Database.

As said earlier, my targeted database is Microsoft SQL Server.

 

Error

Error Messages

Driver file download failed due to a certificate issue.
Try changing the setting `Use Windows trust store` in Preferences->Connections and restart DBeaver.
It might help if you haven’t overridden the trust store.

Image

Textual


Driver file download failed due to a certificate issue.

Try changing the setting `Use Windows trust store` in Preferences->Connections and restart DBeaver. 

It might help if you haven't overridden the trust store.

Do you want to retry?

Reason:

PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

unable to find valid certification path to requested target

 

Troubleshooting

Outline

  1. The error message reads
    • Try changing the setting `Use Windows trust store` in Preferences->Connections and restart DBeaver.
  2. Steps
    • Access the Preferences Menu
    • Access the Connections Tab
    • Review the following options
      • Security
        • Use Windows Trust Store
          • Currently Checked

Images

Image – Window – Preferences

Image – Window – Preferences – Tab – Connections – Pre Change

 

 

Remediation

Outline

  1. Steps
    • Access the Preferences Menu
    • Access the Connections Tab
    • Review the following options
      • Security
        • Use Windows Trust Store
          • Ensure Unchecked
    • Restart DBeaver
      • Please remember to restart DBeaver

Images

Image – Window – Preferences

Image – Window – Preferences – Tab – Connections – Post Changes

 

Database Drivers

Download

Outline

  1. Please reattempt Microsoft SQL Server Driver Download

 

Images

Image – Driver Settings

Image – Driver Settings – Download Driver Files

 

 

Review

Outline

  1. Steps
    • Access Menu Options
      • Database / Driver Manager
    • Driver Manager Window
      • Within the Driver Manager Window
      • Choose Targeted Database
      • Select Driver Type
      • Access the “Edit” button
      • The “Edit Driver < Database>” window will appear
      • Review libraries
        • Driver name
          • com.microsoft.sqlserver.mssql-jdbc
        • Version Number
          • 12.4.1

Images

Image – Driver Settings

Image – Driver Settings – Driver Manager – Edit Driver – Libraries

 

Summary

Java & JDBC is multi-platform.

SSL certificates are files.

They can be stored in OS-centric stores.

Or in Java Stores.

Dbeaver is simply saying we have not done enough with our Microsoft Windows / Java interoperability to seamlessly bridge everything together.

 

Introspection

DBeaver

Metadata

Version Number

Dedication

Always in dedication to Serge Rider and the boys & girls.

Nice, Straight Forward, and Telling error message.

As for me, letting Better Mind cover how to use DBeaver and Microsoft’s SSL Trust Store will be better for my mental wellbeing.

 

Gratitude

Went back and looked at the error message:-

PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target unable to find valid certification path to requested target.

Said something about “unable to find certification path to requested target”.

Them boys off the “Dumbarton Bridge” really had it going.

Thank goodness I was never one of them.

Leave a comment