Upgrade 8.9 LTS to 9.9 LTS - Not using MsSQL anymore

Hello,

we updated from 8.9 LTS to 9.9 LTS. But now, Sonarqube is not using our SQL Server anymore. Instead, is uses the default H2 database. We do not change anything on the configuration. The Server runs with docker compose.

Configuration:

version: '3.3'
 
services:
  sonarqube:
    image: sonarqube:lts-developer
    command: "-Dsonar.search.javaAdditionalOpts=-Dnode.store.allow_mmap=false"
    ports:
      - "9000:9000"
    volumes:
      - sonarqube-conf:/opt/sonarqube/conf
      - sonarqube-data:/opt/sonarqube/data
      - sonarqube-extensions:/opt/sonarqube/extensions
      - sonarqube-bundled-plugins:/opt/sonarqube/lib/bundled-plugins
    environment:
    - SONAR_JDBC_URL=jdbc:sqlserver://xxx.database.windows.net:1433;databaseName=Bxxx;
    - SONAR_JDBC_USERNAME=xxx
    - SONAR_JDBC_PASSWORD=xxx
    - SONAR_ES_BOOTSTRAP_CHECKS_DISABLE=true
   
volumes:
  sonarqube-conf:
      external: true
  sonarqube-data:
      external: true
  sonarqube-extensions:
      external: true
  sonarqube-bundled-plugins:
      external: true

With 8.9 LTS and this configuration, all runs fine without any issues. Updates within 8.9 and restarts where no problems.

What can we do now?

Problem solved. We fiddling around with different configurations , but without any success. Now, we ended with the exact same configuration from above, and all works. I cannot see any differences.

1 Like

Hi I encounter the same issues also the same version from 8.9 to 9.9 I also noticed that the mssql is not connecting to my sonarqube server, may I know what tweak did you do to make it work?/
Ive been changing configurations over and over but I couldnt make it work.

Hello,

we don’t know exactly what solved the issue. We are using now the exact same configuration from above.

Hint: From 8.x to 9.x, the Names of the envrionment variables changed from SONARQUBE_ to SONAR_