Can't connect to SonarQube database after upgrading 9.5 to 9.6

After upgrading SonarQube server from 9.5 to 9.6, the SonarQube service can’t start. Log entries says that “can’t connect to database”, but database parameters are OK.
web.log (12.1 KB)

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.
1 Like

2 posts were merged into an existing topic: How to install SonarQube 9.6 as a windows service?

Hello,

this error message “PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification …” means your APP/JAVA truststore does not contain the SQL Server’s certificate issuer chain.
Load the issuer chain into your java truststore maybe

Szallev_raifhu, setting ‘encrypt=false’ helped to fix connection problem. I’m not using encrypted connection with SQL Server.