title: Sonarqube 5.2 SQLServer connection
body: <p>Since Sonarqube 5.2 is released, the jTDS JDBC driver is no longer supported. We used this driver to connect to our SQLServer instance, but we'll have to switch to the Microsoft SQLServer driver. We're running Sonarqube on Ubuntu and use an Active Directory account to connect to the SQLServer database. Because we're running on Ubuntu we can't use integrated security, so the credentials have to be supplied in the JDBC configuration for Sonarqube. This would result in the following properties:</p>
  
  <pre><code>sonar.jdbc.url=jdbc:sqlserver://sqlserverhost.my.domain.com:1433;databaseName=sonar;selectMethod=cursor
  sonar.jdbc.username=someuser
  sonar.jdbc.password=somepassword
  </code></pre>
  
  <p>This results in SQLServer in a "Login Failed" with the message "Could not find a login matching the name provided."</p>
  
  <p>The next thing I tried was to connect with a username containing the domain, resulting in these properties:</p>
  
  <pre><code>sonar.jdbc.url=jdbc:sqlserver://sqlserverhost.my.domain.com:1433;databaseName=sonar;selectMethod=cursor
  sonar.jdbc.username=DOMAIN\\someuser
  sonar.jdbc.password=somepassword
  </code></pre>
  
  <p>This however also results in a "Login Failed" in SQLServer, the message here is "Attempting to use an NT account name with SQL Server Authentication."</p>
  
  <p>What am I missing?</p>
  
  <p>UPDATE: <br />
  The Sonarqube log can be found here: <a href="http://pastebin.com/AGB9bTQG" rel="nofollow">http://pastebin.com/AGB9bTQG</a><br />
  I can think of one thing which is different from the jTDS connection url: 
  the jTDS connection url contained ";domain=my.domain.com", which the Microsoft SQLServer driver doesn't seem to support. Therefore I tried the DOMAIN\someuser setup which SQLServer refused.</p>