You receive an error message when you try to access Reporting Services after you repair a failed upgrade from SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services


Symptoms


After you repair a failed upgrade from Microsoft SQL Server 2000 Reporting Services to Microsoft SQL Server 2008 Reporting Services, you try to access Reporting Services. When you do this, you receive the following error message:
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.6.54'. The expected version is 'C.0.9.45'. (rsInvalidReportServerDatabase)

Resolution


To resolve this issue, add the RSExecRole role to the db_owner role in the Reporting Services databases. To do this, follow these steps:
  1. Start SQL Server Management Studio, and then connect to the database that hosts the ReportServer database and the ReportServerTempDB database.
  2. In Object Explorer, expand the following nodes:
    1. Expand Databases.
    2. Expand ReportServer.
    3. Expand Security.
    4. Expand Roles.
    5. Expand Database Roles.
  3. Right-click db_owner, and then click Properties.
  4. In the Database Role Properties dialog box, click Add.
  5. In the Select Database User or Role dialog box, type RSExecRole, and then click OK two times.
  6. Repeat steps 2 through 5 for the ReportServerTempDB database. When you repeat step 2b, expand ReportServerTempDB instead of expanding ReportServer.
  7. Restart the Report Server service.

    Note You may have to restart this service two times.

More Information


You receive the error message when you try to access Reporting Services. For example, you receive the error message when you open Report Manager or when you try to send a report.