We recently installed SQL Server 2005 SP3 on all of our live, test and development servers. Since then our users could not use any SSRS report or custom screen. We could not also deploy any SSRS report/custom screen to SQL Server Report Server or run the Report Server or Report Manager Web Service/Application. Anytime users tried to run any report or custom screen, or if we tried to deploy any new/existing SSRS report to Report Server, or tried to run Report Server or Report Manager Web Service/Application, we were getting the following error:
Reporting Services 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 'C.0.8.54'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)
We were getting the above error though we had upgraded both Reporting Services and its database to SP3. Eventually we had to delete SSRS Report Server and Report Manager directories from IIS and recreate them, and it worked. Thanks to Ryan (Ryan Creps from the Network) for the suggestion. Ryan you rock! Thought I would share just in case anyone else finds it useful:
1. Delete Report Server and Report Manager Web Sites from IIS
2. Recreate Report Server and Report Manager Virtual Directories from Reporting Services Configuration Manager from Microsoft SQL Server 2005>Configuration Tools
3. Open SQL Server Business Intelligence Development Studio and then rebuild and redeploy all reports/custom screens (it may not be necessary in your case, but we had to).
4. Then logon into Reporting Services from SQL Server Management Studio and make sure that appropriate credential is set for data source connectivity from Connection page of Data Source Properties window (we had to).
Please, make sure that you have taken necessary backups before doing this. There may be an easier solution but we tried in many other ways and nothing worked.
Mo
National Ballet of Canada