SonarQube Connectionstring SQL Server Named instance and specific Port Number

Today I had to move the Sonar database to another MS SQL instance and had to change the connectionstring. Since the new location was a named instance and is using a specific port number it took a while to get the sonar.jdbc.url correctly. Following Microsoft article got me on the right track.

Thought of sharing this information for others :slight_smile:

Correct set up is:

sonar.jdbc.url=jdbc:sqlserver://SERVERNAME\\INSTANCE:PORTNUMBER;databaseName=DATABASENAME

:warning: Important :warning:
Between the servername and instancename 2 backslashes are needed, one for escaping the special character.

3 Likes

Hi @gCassy,
We are working on a write-up about the JDBC URL connection string improvement in 9.6 and will look for a place to fit this in.

Thanks for pointing it out!

2 Likes