SQL Server Performance

Upgrading SSRS from 2000 to 2008

Discussion in 'ALL SQL SERVER QUESTIONS' started by Alia, Jul 21, 2014.

  1. Alia New Member

    I am trying to upgrade SQL 2000 reporting services to SQL 2008. I backed up the ReportSever and ReportServer TempDB and restored successfully, However when I try to restore the encryption key from SQL 2000 I get this error below. Please suggest.
    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.43'. The expected version is '147'. (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)
    Thank You
  2. melvinlusk Member

    Did you try to do an in-place upgrade or did you restore a SQL 2000 ReportServer DB to a SQL 2008 SSRS installation?

Share This Page