SonarQube 10.3.0.82913 tring to set up domain/username with MS SQL

Must-share information (formatted with Markdown):

  • which versions are you using = SonarQube
  • how is SonarQube deployed = ZIP
  • what are you trying to achieve = for it to run
  • what have you tried so far to achieve this= a lot :slight_smile:

Tring to set up MS SQL and we need to use domain\username. I have configured this service account to run as a windows service but the logs show:
Web.log
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ‘devsecure\svc_cspsonaradmdev’. ClientConnectionId:ae9bcde1-8c5c-4811-80f5-7c5dd9f6551b
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)
at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:304)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:137)
at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(SQLServerConnection.java:6612)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(SQLServerConnection.java:5154)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(SQLServerConnection.java:5087)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7675)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4137)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:3583)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:3172)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:3014)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:1836)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1246)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
… 53 common frames omitted

If I comment out the the log show a blank
#sonar.jdbc.username=sonarqube
#sonar.jdbc.password=mypassword
Web.log:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user ‘’ " .ClientConnectionId:1055e273-36f5-4d7b-b5cb-696d75a6caf6

Hey there.

Do you mind sharing a (redacted) version of the sonar.jdbc.url you’re using? Maybe there’s something conflicting stuck in there.