Sonarqube not connecting to sql server DB

I’m in the process of moving SQ from container instance to azure App service. Setting up SQ was simple; however, I can’t connect to sql server. Somehow the properties setup of version one below gets comment back out when I restart the spp service. At the top of the sonar.properties file it states the following:

Property values can:

  • be overridden by environment variables. The name of the corresponding environment variable is the
    upper-cased name of the property where all the dot (’.’) and dash (’-’) characters are replaced by
    underscores (’_’). For example, to override ‘sonar.web.systemPasscode’ use ‘SONAR_WEB_SYSTEMPASSCODE’.
  • be encrypted. See Security | SonarQube Docs

version one:
sonar.jdbc.password
sonar.jdbc.url
sonar.jdbc.username

version two:
SONAR_JDBC_PASSWORD
SONAR_JDBC_URL
SONAR_JDBC_USERNAME

I have tried both versions and it fails to connect to the database. I found some topics on this in the community but neither provide a solid solution

Hi,

The docs should help.

 
Ann