RS 2005 Upgrade Database Problem

I have installed Reporting Services 2005 on SQL Server 2005 SP2. Then when I try to connect to the Reporting Services i get the error "Invalid Database Version". Any suggest?

Try applying Service Pack 2 to the Reporting Services installation as well.

Larry

|||

Thanks,

i get some problems if i'll install for the second time SP2 on SQL Server 2005 with SP2.

|||

I just read the release notes for SP2 (http://download.microsoft.com/download/2/B/5/2B5E5D37-9B17-423D-BC8F-B11ECD4195B4/ReadmeSQL2005SP2.htm#_reporting_services) and found the following:

5.4.6 SP1-to-SP2 Upgrade Does Not Update the Report Server Database in Some Cases

The type of credentials that are specified on the report server database connection will determine whether Setup can upgrade a report server database from an SP1 or CTP version of SP2 to the final release of SP2.

If the report server connects to the report server database using database credentials or a Windows user account that differs from the one used to run the Report Server Windows service, the database will not be upgraded when the rest of the software is upgraded. If this occurs, you must use the Reporting Services Configuration tool to upgrade the report server database manually. On the Database Setup page, click Upgrade to apply the SP2 format to the report server database.

Does this match your problem? Did you install SQL Engine, SP2, and then SSRS on the same machine in that order? Please give a bit more detail about what you have done and what has happened.

Also, I believe there is a command line parameter that you can provide the service pack to force it to install. I will provide it when I find it.

Larry