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:


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


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!