Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. 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

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)

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: kb, kbprb, kbtshoot, kbentirenet, kbexpertiseadvanced, sql2008relnote, sql2008relnotereportingservices

↑ Back to the top

Article Info
Article ID : 956160
Revision : 5
Created on : 8/19/2020
Published on : 8/20/2020
Exists online : False
Views : 74