9.6 Cannot connect to SQL Database, 9.5 Can

SonarQube
, ,
1

I am trying to upgrade from 9.5 to 9.6 using a locally installed MSSQL database on a Windows Server.

9.5 has been working for some time. I have copied the DB connection details into the sonar.properties and did even try copying the whole config file from 9.5 over.

Version 9.6 just will not connect so I have gone back to 9.5 which continues to work correctly. I have the versions in 2 separate folders as required so I can easily swap between them.

sonar.jdbc.username=sonarqube
sonar.jdbc.password=******
sonar.jdbc.url=jdbc:sqlserver://localhost;databaseName=Sonar

2022.08.18 11:34:56 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 9.6.0.59041 / 688f079e390ba7e89a412b29fe464dbdf3c19908
2022.08.18 11:34:56 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://localhost;databaseName=Sonar
2022.08.18 11:34:56 WARN  web[][o.s.c.a.AnnotationConfigApplicationContext] Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'jdk.internal.loader.ClassLoaders$AppClassLoader@5c29bfd-org.sonar.db.DefaultDatabase': Initialization of bean failed; nested exception is java.lang.IllegalStateException: Fail to connect to database
2022.08.18 11:34:56 ERROR web[][o.s.s.p.PlatformImpl] Web server startup failed


2022.08.18 11:37:49 INFO  web[][o.s.p.ProcessEntryPoint] Starting Web Server
2022.08.18 11:37:50 INFO  web[][o.s.s.p.LogServerVersion] SonarQube Server / 9.5.0.56709 / 3185a5669fdfaf7e4fa6dc7876e0b0dfd5d2aae7
2022.08.18 11:37:51 INFO  web[][o.sonar.db.Database] Create JDBC data source for jdbc:sqlserver://localhost;databaseName=Sonar
2022.08.18 11:37:53 INFO  web[][o.s.s.p.ServerFileSystemImpl] SonarQube home: C:\sonarqube-9.5.0.56709
2022.08.18 11:37:53 INFO  web[][o.s.s.u.SystemPasscodeImpl] System authentication by passcode is disabled
2