Backup & Restore encryption key

Hello!

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

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?

|||

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.

|||

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

|||We are investigating potential upgrade issues with your installation. I'll post the results when I have them. Sorry for the delay.|||

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

|||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