Updated SonarQube | DB connection fails

[Giorgio_Ziu]

The situation

Hello everyone, after updating SonarQube from the 9.5 version to the 9.6 version, the connection with the DB fails.

The problem

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: “PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target”.

What I have

• Windows Server 2016 Standard
• SonarQube Community Edition 9.6
• Microsoft SQL Server 2019
• OpenJDK 11

The logs

es.log (4.5 KB)
sonar.log (2.8 KB)
SonarServiceWrapper.wrapper.log (64 Bytes)
web.log (12.2 KB)

[Colin]

SQL Server DB connection fails when using docker image for 9.6, fine with 9.5

Hey there. Make sure you read the upgrade notes Microsoft SQL Server changes in configuration and Integrated Authentication If your Microsoft SQL Server doesn’t support encryption, you will need to add encrypt=false to the JDBC URL connection string. (SONAR-16249). If your Microsoft SQL Server requires encryption but you don’t want SonarQube to validate the certificate, you will need to add trustServerCertificate=true to the JDBC URL connection string.