which versions are you using (SonarQube, Scanner, Plugin, and any relevant extension)
Community Edition - Version 10.2 (build 77647)
how is SonarQube deployed: zip, Docker, Helm
Azure App Service, this is used for the test environment to test SonarQube before upgrading the one we have in production.
what are you trying to achieve
Trying to connect to the SQL Database in Azure with SonarQube instance as an App Service.
what have you tried so far to achieve this
Configured the following
User credentials.
# Permissions to create tables, indices and triggers must be granted to JDBC user.
# The schema must be created first.
sonar.jdbc.username=***
sonar.jdbc.password=***
and
#----- Microsoft SQLServer 2014/2016/2017/2019/2022 and SQL Azure
# A database named sonar must exist and its collation must be case-sensitive (CS) and accent-sensitive (AS)
# Use the following connection string if you want to use integrated security with Microsoft Sql Server
# Do not set sonar.jdbc.username or sonar.jdbc.password property if you are using Integrated Security
# For Integrated Security to work, you have to download the Microsoft SQL JDBC Auth 12.2.0 package from
# https://github.com/microsoft/mssql-jdbc/releases/download/v12.2.0/mssql-jdbc_auth.zip
# and 'mssql-jdbc_auth-12.2.0.x64.dll' to your path.
sonar.jdbc.url=jdbc:sqlserver://***.database.windows.net:1433;database=***;encrypt=true;trustServerCertificate=True;
After restarting the app service all gets commented out again.