Changing database settings from H2 to SQL Server

[ganncamp (G Ann Campbell)]

Hi,

@Shankar

Not sure whether the default database can be changed

Yes, you can change the DB. You have full access and full rights to do so.

@Shankar

Though I have commented the default database H2 portion in the conf and uncommented SQL Server section, application continue to use only the default H2 database.

If you’ve correctly specified the connection values for SQL Server, then SonarQube should be connecting to it. If it’s not connecting, then either

• the server logs, probably web.log will have errors
• not all the values to make a connection were present & SonarQube is falling back to the default: H2 (yes, despite the fact that that’s commented out in the config file)

 
Ann