July 21, 2014 at 12:22 pm
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
July 26, 2014 at 11:33 pm
scarydba (7/21/2014)
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
I haven't done this with ReportServer but when upgrading other SQL 7/2000 parts to 2008 or later, I've found the easiest path (path of least problems) being an intermediate upgrade to 2005 and then onwards.
😎
July 28, 2014 at 5:37 am
Have you used Reporting Services Configuration Manager to point at the newly restored databases?
That should trigger the databases being automatically upgraded which it doesn't sound has happened yet.
July 28, 2014 at 12:15 pm
Thank you !
I am planning to try on SQL 2005 now.
July 29, 2014 at 1:01 am
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply