SonarQube-MSSQL-JDBC-Compatibility

SonarQube Server / Community Build
,
1

Hello Team, Below is our current configuration.

  • Using - SonarQube Server - 9.4, & ZIP Deployed.
  • Checking the version compatibility of SonarQube with MSSQL JDBC jars.
  • Planning to Upgrade to 10.8.1.

Can you please confirm whether the “mssql-jdbc-12.8.1.jre11” that comes with the “sonarqube-enterprise-10.8.1.101195” is compatible with the SQL Server 2014 ?

1.The support matrix from the Microsoft website says that the 12.8-mssql-jdbc doesn’t support SQL Server 2014.
2. Whereas the SonarQube-server-10.8-Database requirements page says it supports SQL Server 2014 (MSSQL Server 12.0)

Please let us know on the above SonarQube-MSSQL-JDBC jar version compatibility.

Thankyou…

2

Hey @Srini1!

That may have been an error on our part – and I’ll check to see if it’s worth that we update the old docs.

However, you should not target an upgrade to v10.8.1 – you should be targeting v2025.1 LTA, which documents that SQL Server 2014 is not supported.. v10.8.1 is not a long-term active (LTA) version and will receive no further updates.

5

Hi Colin,
Request you to please update any SonarQube-Database requirements page, as you mentioned.
(I see 12.6.4-jdbc jar supports both 2014 & 2022. Will you be updating the jar file in the downloadable for 10.8?)

Our organization is having plans to upgrade 2014-MSSQL Server to 2019/2022 which may take some time to implement in all environments. Hence, targeted to 10.8.1 assuming the last version to support MSSQL-2014.

Seems we can upgrade to 9.9LTA, which supports 2014&2022-MSSQL and later upgrade to 2025.1LTA.
Please let me know your suggestion on this path.

Thankyou.

6

I would indeed suggest that you upgrade to v9.9 LTA, and once your organization has updated to SQL Server 2019/2022, continue onto v2025.1.

1 Like
9

Hi Colin,
We are migrating our DB to another instance & upgrading to MSSQL-2022 for our SonarQube-DEV instance.
hence, we have Changes in DB-URL.

Seems as per the documentation: During this Change, the Server-ID will be re-generated & the license gets invalidated…

Can we get the new license key within a short period of time, if we email to contact@sonarsource.com?

Thank you.

10

Starting in SonarQube v9.9 LTA you benefit from a grace period where you can extend your license up to 7 days after a Server ID change. But you will also have to get in touch with contact@sonarsource.com for your new, permanent license.

11

That really helps.
We are in 10.8 for our Dev & in 9.9 in PROD..

That gives enough time to coordinate with SonarSource for a new license.

Thankyou..