I’m installing SonarQube 8.7 onto a Windows Server 2019 server in Azure and am trying to simply get the MSSQL database built out. I’m running MSSQL 2019 Express. My problem is that when I start StartSonar.bat for the first time, it never adds the database schema to my database. The console doesn’t seem to have any errors either.
I made a blank database called “sonar” and create a user, “sonarqube”, and given it db_owner permissions over the sonar database. I also made sure both the collation and READ_COMMITED_SNAPSHOT settings are proper.
In my server.properties file, I have the following connection strings…
sonar.jdbc.url=jdbc:sqlserver://VF-APPS-01\SONARQUBE;databaseName=sonar sonar.jdbc.username=sonarqube sonar.jdbc.password=mypassword
I’ve confirmed the user can open the database perfectly fine so it’s not a permission issue. I run the .bat file as admin so not that. I have tried using “VF-APPS-01/SONARQUBE” or “VF-APPS-01\SONARQUBE”, nothing seems to work.
My console just sits and looks like this…
Any help would be very much appreciated.