Ugrade/migrate SSRS 2000 to SSRS 2008

  • arturopw

    Old Hand

    Points: 313

    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.

    ERROR MESSAGE

    Microsoft.ReportingServices.WmiProvider.WMIProviderException:

    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:

    SSRS

    Product Version: 10.0.2531.0 ((Katmai_PCU_Main).090329-1015)

    Message Source: ReportServicesConfigUI.WMProvider

    LinkID:20476

    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.

    http://msdn.microsoft.com/en-us/library/ms143724.aspx

    http://msdn.microsoft.com/en-us/library/cc281308.aspx

    http://technet.microsoft.com/en-us/library/ms156421.aspx

    http://support.microsoft.com/kb/956160

  • Gift Peddie

    SSC Guru

    Points: 73570

    I am assuming you are missing SSRS 2000 SP2 which is required for upgrade to SSRS 2008 and you need these links instead of the ones you posted. Now I am not saying those are not relevant.

    http://msdn.microsoft.com/en-us/library/ms143747.aspx

    http://msdn.microsoft.com/en-us/library/ms144256.aspx

    Kind regards,
    Gift Peddie

  • arturopw

    Old Hand

    Points: 313

    It sounds like this could be it. Since it's a production system I'll have to wait to apply SP2 but I'll post my results when I have done so. Thank you. Much appreciated.

  • Gift Peddie

    SSC Guru

    Points: 73570

    I have helped with SSRS 2000 to SSRS 2005 upgrade and the main issue was upgrade from SSRS 2000 Standard comes with base restrictions which creates issues for the upgrade so you need to read the upgrade to 2005 docs very carefully so you will avoid what creates issues. You could also create a sandbox version from your production code so you could upgrade without affecting your production code. I have an existing thread I will post it later.

    Kind regards,
    Gift Peddie

  • cybersurfer.411

    SSC Enthusiast

    Points: 111

    Hey, Any luck with this issue? I am having the same issue in restoring keys. Thanks in advance!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply