System authentication by passcode is disabled

Hello,
I am running SonarQube 7.7 in Windows 2016 server. I configure SQL Authentication as follows in sonar.properties file.

sonar.jdbc.username=sonaruser
sonar.jdbc.password=***************
sonar.jdbc.url=jdbc:sqlserver://sonardbserver;databaseName=sonar

Now SonarQube server is offline. web log shows as follows. Please help

019.10.22 12:50:39 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 7.7.0.23042 / 1dcac8b8de36b377a1810cc8f1c4c31744e12729
2019.10.22 12:50:39 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://sonardbserver;databaseName=sonar
2019.10.22 12:50:40 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: D:\DevOps\Sonarqube\sonarqube-7.7
2019.10.22 12:50:40 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2019.10.22 12:50:40 ERROR web[][o.s.s.p.Platform] Web server startup failed
java.lang.IllegalStateException: Can not check that table schema_migrations exists
	at org.sonar.db.DatabaseUtils.wrapSqlException(DatabaseUtils.java:324)
	at org.sonar.db.DatabaseUtils.doTableExists(DatabaseUtils.java:319)
	at org.sonar.db.DatabaseUtils.tableExists(DatabaseUtils.java:290)
	at org.sonar.server.platform.db.migration.history.MigrationHistoryTableImpl.start(MigrationHistoryTableImpl.java:44)
	at java.util.Optional.ifPresent(Optional.java:159)
	at org.sonar.server.platform.platformlevel.PlatformLevel2.start(PlatformLevel2.java:107)
	at org.sonar.server.platform.Platform.start(Platform.java:211)
	at org.sonar.server.platform.Platform.startLevel2Container(Platform.java:177)
	at org.sonar.server.platform.Platform.init(Platform.java:87)
	at org.sonar.server.platform.web.PlatformServletContextListener.contextInitialized(PlatformServletContextListener.java:45)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4817)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5283)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1423)
	at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1413)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The database name component of the object qualifier must be the name of the current database.
	at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)
	at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
	at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
	at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
	at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQueryInternal(SQLServerPreparedStatement.java:344)
	at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetFromStoredProc(SQLServerDatabaseMetaData.java:301)
	at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getResultSetWithProvidedColumnNames(SQLServerDatabaseMetaData.java:316)
	at com.microsoft.sqlserver.jdbc.SQLServerDatabaseMetaData.getTables(SQLServerDatabaseMetaData.java:481)
	at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getTables(DelegatingDatabaseMetaData.java:902)

Hi,

It looks like your problem is your JDBC URL. After a brief search on that error string, I found this:

https://www.tsql.info/error/msg-15250-level-16-the-database-name-component-of-the-object-qualifier.php

 
Ann

Thank you Ann. Now SonarQuber is working.

Thanks
Pradeep

1 Like