When Upgrading 9.2 to 9.9, an error occured like "sqlserver.jdbc.SQLServerException"

[Anil_Guney (Anıl Güney)]

Hello,

We encountered a problem to upgrade SonarQube from 9.2 to 9.9. When we try to trigger StartSonar.bat on CMD, we notice that the web service could not be started. When we check the web logs, there were some errors like below:

We changed our “jdbc” configurations on sonar.properties file and we added “encrypt=false;trustServerCertificate=true” end of the url. We also tried to add “encrypt=true;trustServerCertificate=true”. However, it did not work. What should we do to overcome this problem?

jdbc configuration:
sonar.jdbc.url=jdbc:sqlserver://dbservername;databaseName=dbName;encrypt=false;trustServerCertificate=true
sonar.jdbc.username=Username
sonar.jdbc.password=Password

Server: Windows Server 2012
Java Version: java 17
Database Provider: MS SQL

[ganncamp (G Ann Campbell)]

Hi,

Welcome to the community!

We really prefer the text of logs to screenshots like yours, since they can be quite hard to read.

Did you also replace the mssql-jdbc_auth DLL?

 
Ann