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

Article translations Article translations
Article ID: 956160 - View products that this article applies to.
Expand all | Collapse all

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.

Properties

Article ID: 956160 - Last Review: March 19, 2009 - Revision: 2.0
APPLIES TO
  • Microsoft SQL Server 2008 Reporting Services
  • Microsoft SQL Server 2000 Reporting Services
Keywords: 
sql2008relnotereportingservices sql2008relnote kbexpertiseadvanced kbtshoot kbprb KB956160

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com