Recently we upgraded our SSRS servers host OS from Windows Server 2003 to Windows Server 2008 R2. The reporting databases are in different server. So we had the following plan.
- Flatten SSRS Server
- Install Windows Server 2008 R2
- Install SSRS
- Attach the existing Database.
The plan looks good, but the challenge was waiting for us after the update. The step 4 was failing with an error “The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database.”
After a bit of Bing! we realized the importance of symmetric key. We need to have a backup of symmetric key when ever we perform any of the following operations.
-
Changing the service account for the Report Server service.
-
Migrating a Reporting Services installation to a different computer.
-
Configuring a new report server instance to share or use an existing report server database.
No comments:
Post a Comment