Since Sonarqube 5.2 is released, the jTDS JDBC driver is no longer supported. We used this driver to connect to our instance of SQLServer, but we will have to switch to the Microsoft SQLServer driver. We run Sonarqube on Ubuntu and use an Active Directory account to connect to the SQLServer database. Since we work on Ubuntu, we cannot use integrated security, so credentials must be provided in the JDBC configuration for Sonarqube. This will result in the following properties:
sonar.jdbc.url=jdbc:sqlserver://sqlserverhost.my.domain.com:1433;databaseName=sonar;selectMethod=cursor
sonar.jdbc.username=someuser
sonar.jdbc.password=somepassword
This leads to the fact that SQLServer appears in the "Login Error" with the message "Could not find the login that matches the specified name."
The next thing I tried is a connection with a username containing a domain, resulting in the following properties:
sonar.jdbc.url=jdbc:sqlserver://sqlserverhost.my.domain.com:1433;databaseName=sonar;selectMethod=cursor
sonar.jdbc.username=DOMAIN\\someuser
sonar.jdbc.password=somepassword
This also results in "SQLServer login error", the message "Attempting to use the NT account name with SQL Server authentication" appears here.
What am I missing?
UPDATE:
Sonarqube magazine can be found here: http://pastebin.com/AGB9bTQG
I can think of one thing that is different from the jTDS connection url: The jTDS connection url contains "; domain = my.domain.com", which does not appear to support the Microsoft SQLServer driver. So I tried installing DOMAIN \ someuser, which SQLServer failed.