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