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