Sonar - LucianCumpata/DevOps GitHub Wiki

• How to setup SonarQube on a Windows machine with SQL Server?

Go here and download SonarQube Community Edition.

Extract the archive to C:\sonarqube

You will also need Java 8+, in this example we will use AdoptOpenJDK. Download it from https://adoptopenjdk.net/ and choose the 11 or 12 version.

Launch SQL Server configuration manager and enable the TCP/IP protocol in SQL Server Network Configuration tab.

Go to the Windows Services and start "SQL Server Browser" service.

Launch MSSMS and create a new database named SONAR were Collation MUST be case-sensitive (CS) and accent-sensitive (AS). For example choose "SQL_Latin1_General_CP1_CS_AS"

It might be a good idea to restart SQL Server service.

To configure integrated security, click here to download Microsoft SQL JDBC Driver 7.2.2 package and copy the 64-bit version of sqljdbc_auth.dll to C:\Windows\System32

Edit the sonar.properties located in C:\sonarqube\conf folder and find the next line:

#sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar;integratedSecurity=true

Uncomment it and change the databaseName to your own name (in this example, change it to "SONAR" in UPPERCASE)

Save the changes and go to C:\sonarqube\bin\windows-x86-64 and launch StartSonar.bat