Logs state database collation is wrong but its not

SonarQube Server / Community Build
, , ,
1

I’m having some major issues deploying the Enterprise edition using SQL authentication on MSSQL express 2019. The web server logs show that the SonarCube services for some reason think the collation is incorrect when it is indeed correct. I can also see it has made the schema_migrations table in the DB so I know it is able to connect to the database.

Setting are:
sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=sonar
sonar.jdbc.username=SonarQube
sonar.jdbc.password=REDACTED

image
image1783×930 176 KB

2

Hi,

Welcome to the community!

You assert that the collation is correct, but your screenshot shows a difference of ...CI_AS versus ...CS_AS? So I believe your collation is Case Insensitve instead of Case Sensitve.

 
HTH,
Ann