Hello, I could use some help in resolving an issue with SSRS 2008. I am getting the following error when I try to restore the Encryption Key using the RS Configuration Manager that comes with 2008. Any help would be appreciated. Thanks in advance.
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.51'. The expected version is 'C.0.9.45'. (rsInvalidReportServerDatabase)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.RestoreEncryptionKey(Byte encryptedBytes, String password)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte encryptedBytes, String password)
Version Details attached to Error Message:
Product Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015)
Message Source: ReportServicesConfigUI.WMProvider
Here is what I am doing.
I currently have SSRS 2000 installed and am trying to upgrade and migrate it to SSRS 2008 on new machines (one for db and the other for the service). These are the steps I took. Both 2008 servers have 2008 and SP1 installed on them (version 10.0.2531.0). I took the following steps.
backup up source SSRS dbs
backup source encryption key
backup source .config files
install SSRS 2008 on destination SSRS server with “Install but do not configure” option.
Setup RSExecRole role on destination DB server.
Restore dbs on destination server. This SHOULD UPGRADE dbs to 2008.
Copy over .config files to new server (all files but rsreportserver.config since I could not restart the service with it.)
Finish config using Config manager (URLs, restore DB, etc) and start SSRS Service.
Restore source encryption key on destination SSRS (service) server. – I get the error here.
I’ve used the following msdn documentation but have had no luck.