As noted in a previous post, you can host a SonarQube on an Azure App Service, thanks to Nathan Vanderby, a Premier Field Engineer from Microsoft. He created an ARM template to run the SonarQube installation behind an Azure App Service with a Java host. This saves you a lot of steps mentioned above! You can find the scripts for it on GitHub or deploy it from the big
deploy on Azure button.
Several benefits you get from hosting SonarQube on an App Service:
The biggest benefit is that the App Service already has Java installed! So no more downloading the JRE by hand, installing it manually and starting the SonarQube service by hand!
Setting up a new SonarQube server this way is a breeze. Updating it should be easier as well and that is the another big plus: you now have the ability to run the installation on a Deployment Slot, let it update the database and then switch to the slot. No manual updating anymore!
After creating the basic SonarQube App Service from GitHub or the ARM template, you need to create a new SQL database. Do note that you need to set the database to the correct collation for it to work:
There are two options to create a new user in the database. You can create one like you would do in a full MSSQL server installation, by using the
master database. Running this way on a Azure SQL Db has a couple of downsides:
A Contained user is a user account created inside the database itself, making it easier to move if needed.
Run this statement in a query editor connected to your database. Of course, you can make the user a
data_writer or something else.
Since I need the application using this connection also creating the tables, stored procedures, etc, I gave it DBO rights in this database.
CREATE USER [MyUser] WITH PASSWORD = 'Secret'; EXEC SP_ADDROLEMEMBER N'db_owner', N'MyUser'
To create a regular MSSQL user if you do not want to have it contained in the database (see above), you can create a new SQL user by running this on the
CREATE LOGIN SonarQubeUI WITH password='<make a new secure password here>';
Then create a login from the new user account by running this statement
on the new database (you cannot use a
use database_name statement in Azure SQL database, so you need to switch to it in the UI of your query editor):
CREATE USER SonarQubeUI FROM LOGIN SonarQubeUI
Copy these settings from the previous steps for next use:
In the Azure Portal, find your new App Service and navigate to Advanced Tools –> Kudu
Open a debug console:
And navigate to the configuration folder of your SonarQube and open the file
Update these properties:
sonar.jdbc.username=SonarQubeUI sonar.jdbc.password=<your sql server user password> sonar.jdbc.url=jdbc:sqlserver://mysqlserver.database.windows.net:1433;databaseName=SonarQubeDb
Note the portnumber and the property of
databaseName instead of
database (this was changed in SonarQube > 5.3).
Also note that the database name your enter is CASE-SENSITIVE! SonarQube is running on Java, hence the sensitivity.
Do note the Server base URL in SonarQube, I missed it the first time.
By default, this is empty!
Server base URL to set the url to match the url of the App Service.
If you don’t want to show the state of your projects to the entire world, don’t forget to change the default setting for this. Since the free edition is available for open source projects, this setting is
on by default.
You can find it under Administration: