sonarqube - Sonar with SQL Server 2008 -

i trying setup sonar 3.6 and/or 3.6.2 sql server 2008. testing in preparation of conversion mysql sql server. getting no errors when running:

sonar.sh console 

console output:

running sonar... wrapper  | --> wrapper started console wrapper  | launching jvm... jvm 1    | wrapper (version 3.2.3) http://wrapper.tanukisoftware.org jvm 1    |   copyright 1999-2006 tanuki software, inc.  rights reserved. jvm 1    | jvm 1    | 2013-07-31 11:41:12.374:info:oejs.server:jetty-7.6.11.v20130520 jvm 1    | jruby limited openssl loaded. http://jruby.org/openssl jvm 1    | gem install jruby-openssl full support. jvm 1    | 2013-07-31 11:41:43.963:info:oejsh.contexthandler:started o.e.j.w.webappcontext{/,file:/alm/sonar-3.6.2/war/sonar-server/},file:/alm/sonar-3.6.2/war/sonar-server jvm 1    | 2013-07-31 11:41:44.034:info:oejs.abstractconnector:started selectchannelconnector@0.0.0.0:29000 

i running database on remote server. should not problem though.

i able access server same credentials dbvisualizer, imagine should go through sonar.

the driver using 1 bundled sonar.

the error getting web based when try , access server.

we're sorry, went wrong.  please try in few minutes , contact support if problem persists.  <%= link_to "go homepage", home_path %> 

when use h2 embedded database have no problem accessing it, deduce problem database setup.

--------------------------------------------------------- # web settings - standalone mode # these settings ignored when war file deployed java ee server. #--------------------------------------------------------- # listen host/port , context path (for example / or /sonar). default values  0.0.0.0:9000/. sonar.web.host:                           localhost sonar.web.port:                           9500 sonar.web.context:                        /sonar  # log http requests. deactivated default. #sonar.web.jettyrequestlogs: ../../logs/jetty-yyyy_mm_dd.request.log #sonar.web.jetty.threads.min:              5 #sonar.web.jetty.threads.max:              50  #----------------------------------------------------------------------- # database # # important : embedded database h2 used default. # recommended tests only. please use external database # production environment (mysql, oracle, postgresql, sqlserver) # #-----------------------------------------------------------------------  #----- credentials # permissions create tables , indexes must granted jdbc user. # schema must created first. sonar.jdbc.username:                       sonar sonar.jdbc.password:                       sonar  #----- embedded database h2 # note : not accept connections remote hosts, # sonar server , maven plugin must executed on same host.  # comment following line deactivate default embedded database. #sonar.jdbc.url:                            jdbc:h2:tcp://localhost:19092/sonar #sonar.jdbc.driverclassname:                org.h2.driver  # directory containing h2 database files. default it's /data directory in sonar installation. #sonar.embeddeddatabase.datadir:/alm/sonar/apache-tomcat-7.0.41/data # h2 embedded database server listening port, defaults 9092 #sonar.embeddeddatabase.port:               19092 ... ...  #----- microsoft sqlserver # jtds open source driver available in extensions/jdbc-driver/mssql. more details on http://jtds.sourceforge.net sonar.jdbc.url                              jdbc:jtds:sqlserver://(remote ip address);instance=mssqlserver;databasename=sonar;selectmethod=cursor;  # optional properties sonar.jdbc.driverclassname:                net.sourceforge.jtds.jdbc.driver 

the sonar username have has permissions sonar database.

i missing small appreciated.

solved it:

the problem needed create sonar schema, , associate sonar user sonar database.

i ensured sonar user had permissions needed in order create database. started perfectly.