Backing-up Encryption Key multiple times does what?

Hi JFoushee,

In SQL Server Reporting Services (SSRS), a backup copy of the key is required for many routine operations, and enables us to reuse an existing report server database in a new installation. The following maintenance tasks require that you have a valid copy of the symmetric key:

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

We only need to back up one copy of the symmetric key. There is a one-to-one correspondence between a report server database and a symmetric key. We should backup the encryption keys when we configure a Reporting Services installation for the first time. We should also backup the keys any time we change the identity of the service accounts or rename the computer.

Reference: http://technet.microsoft.com/en-us/library/ms157275.aspx

There is a document about Reporting service ENCRYPTION KEY automated backup REPORT utility, you can refer to it.

http://blogs.msdn.com/b/selvar/archive/2013/03/27/reporting-service-encryption-key-automated-backup-report-utility.aspx

Hope this helps.

Regards,

Alisa Tang

If you have any feedback on our support, please click here.

---

Alisa Tang

TechNet Community Support