Backup & Restore encryption key

Hello!< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

I started Configure Report Server (2005) and have executed backup of the encryption key.

Problem occurred on restore of the encryption key as following error (I have provided correct backup snk):

ReportServicesConfigUI.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.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.RestoreEncryptionKey(Byte[] encryptedBytes, String password)

ReportingServer sites stop working with similar error (browsing by IE):

The found version is 'C.0.8.39'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase)

ReportingServer services are all locked by this.

Can you please tell how to resolve this problem

Thank you very much!

vbrada

Answer this question

Backup & Restore encryption key

Alexkobe
There were a few issues with this as the database versions. But you can manually hack stored procedure GetDBVersion in ReportSever database to reflect the database version mentioned by the key
ALTER PROCEDURE [dbo].[GetDBVersion]
@DBVersion nvarchar(32) OUTPUT
AS
set @DBVersion = 'C.0.8.39'
Change it back once key is installed
d bonamie
It seems your RS installation is a pre-RTM build, but you are using RTM version of the tools. I am not sure about the build number 'C.0.8.39'. It isn't one of the IDW builds. Therefore you may not be able to upgrade it to RTM.

Which build did you install
jab_be

Hi!

It is Team Foundation's Reporting Service database (SQL2005 std).

I have not upgraded Reporting Service database.

I have not created or customized any reports.

Team Foundation version is Beta 3 refresh.

I have started a backup of the encryption key by "Configure Report Server" and then detached Reporting Service databases.

Then I attached it back and tried to restore encryption key with error. After database attach back, Reporting site stopped working correctly.

Whole procedure was for testing migration/backup of TFS data to another ATDT server (single server TF).

Thanks!

V.
bigboyc

Using Configuration Manager, try to upgrade the RS Database by clicking the "Database Setup" tab and hitting "Upgrade".
itisasif

If this can help...all tasks I have done (and I can remember):

1. Backup of the Reporting encryption key.

2. All SQL servers DB detaching / attaching.

3. Installation of the last two sec. updates (between: 1. feb - 11. feb.)

4. Updating installation of the SQL server...( SQL Manager Studio was missing/not installed in first place)

Also...in prior...backup of the STS_[srvname]_1 database has been failed on:

System.Data.SqlClient.SqlError: The backup of the file or filegroup "sysft_ix_STS_[servername]_1" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. (Microsoft.SqlServer.Smo)

thanks
polonius
We are investigating potential upgrade issues with your installation. I'll post the results when I have them. Sorry for the delay.
Backup & Restore encryption key

Answer this question