Recently I had to uninstall and re-install SQL 2005 Reporting Services for SCOM 2007 R2.
While configuring it using the Reporting Services Configuration Manager, under the Database Setup tab I was prompted to upgrade the database version. When I clicked OK, I got the following messages: –
The database version (C.0.8.40) does not match your Reporting Services installation. You must upgrade your Reporting Services database.
And then: –
Couldn’t generate the upgrade script. There is no upgrade script available for this database version.
Which had further details: –
ReportServicesConfigUI.WMIProvider.WMIProviderException: The version does not match a supported version.
Additionally, trying to access the reporting page via my browser gave me this error: –
The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is ‘Unknown’. The expected version is ‘C.0.8.40’. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
The upgrade was failing because of a version mismatch, and this was caused by the Reporting Services component being installed individually from the SQL core services. The solution was to apply the latest service pack (SP3) to the SQL installation, which re-aligned the versions and allowed the ReportServer database to be upgraded via the Reporting Services Configuration Manager.