Migration Issue - SSRS

Recently we have migrated report server, before migration we have taken backup of the reportserver and restored in the new server. ReportServer database is has all the data (data has been properly copied from old to new). But when i am doing configuration changes in the new server, by clicking on web services it is showing the following error...

The report server installation is not initialized. (rsReportServerNotActivated) Get Online Help

asked Mar 22 '12 at 01:36 PM in Default

Mohan
314 ● 17 ● 30 ● 42

Thanks for the information, we have pointed the SSRS instance to the Copied DB. We have done the following

Restored the old SSRS Report Server
After restoring, i am able to access ReportServer DB from SSMS
In Report Server Configuration, Mapped the DB to new Instance.
We have observed that in ReportServer DB there is a table called "Keys", in that two rows are available with data like MachineName and SymmetricKey like that
The Restored Database SymmentricKey was NULL
Actually we are trying to delete the Encryption Keys, we have got the error as "Symmentric Key shoud not be NULL"
Then removed the row from the table and restarted the Reporting Services then automatically one new row has been inserted in that table with the Machine Name and Symmentric Key.
Now from Configuration, we tested "Report Manager URL", it was working fine. All the old server reports we have got it.
Then for testing purpose we are testing the reports, few reports are working fine. But for few reports it is showing as the followg error.

An error has occurred during report processing. (rsProcessingAborted) The report server is unable to access encrypted data. Apply a back-up key or delete all encrypted content. (rsEncryptedDataUnavailable)

Then we tried to delete the Entrycption key but it was not deleting. Giving an error.

One more thing, we have not taken the backup of the old server encryption key.

This is very urgent for me ..

Thanks

Mar 28 '12 at 12:00 PM Mohan

(comments are locked)

1 answer:

Have you configured the new SSRS instance using the Reporting Services Configuration Manager and pointing them to the copied database?

It's look like you have only copied the DB, but not re-configured the SSRS instance to point to that DB.

Also have you made a backup of the encryption key and restored it on a new instance? It is not enough to backup and restore the DB if you want to all the sensitive information (like passwords in data sources) to be available on new instance.

EDIT
If you have delete encryption keys from the Keys table (or in case of database movement) and you do not have a backup of the encryption keys, than you have to delete all the encrypted information from the Repoting Database (all user names and passwords from all the data sources and subscriptions) and re-enter those information again manually.

Some of the reports may be working if they are using integrated authetication, but datasources with stored credentials are not accessible as they are encrypted by different encryption key. (after deletion of the key row in the Keys table, a new encryption key is created automatically).

To delete the encrypted conted, you have to use Reporting Services Configuration Manager, connect to the SSRS instance and in the Encryption Keys tab there is button to delete all the encrypted content.

In case you have a backup of encryption key, you should restore it. Also If you delete the encryption content, make a backup of current one for future use, as you will save a lot of work spent on manual re-defition of data sources and subscriptions in case of DB restore after failure or database movements.

answered Mar 22 '12 at 07:36 PM