Tuesday, January 11, 2011

Moving SSRS Report DB

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.

  1. Flatten SSRS Server
  2. Install Windows Server 2008 R2
  3. Install SSRS
  4. 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

Teams PowerShell

 The PowerShell helps to get quick meta data around Teams. Install-Module -Name MicrosoftTeams Connect-MicrosoftTeams Get-TeamAllChannel...