Encryption key - do I need to restore it or not ?

Hi @Anne ,

Reporting Services uses encryption keys to secure credentials and connection information that is stored in a report server database.

It is necessary to restore the backup copy of the encryption key when any of the following events occur:

Changing the Report Server Windows service account name or resetting the password. When you use the Report Server Configuration Manager, backing up the key is part of a service account name change operation.

Renaming the computer or instance that hosts the report server (a report server instance is based on a SQL Server instance name).

Migrating a report server installation or configuring a report server to use a different report server database.

Recovering a report server installation due to hardware failure.

More details about SSRS encryption keys please refer:

https://video2.skills-academy.com/en-us/sql/reporting-services/install-windows/ssrs-encryption-keys-manage-encryption-keys?view=sql-server-ver15

https://video2.skills-academy.com/en-us/sql/reporting-services/install-windows/ssrs-encryption-keys-back-up-and-restore-encryption-keys?view=sql-server-ver15

So if you changed the existing server from one name to another that hosts the report server, please also remember to restore encryption key.

Regards，

Zoe

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

What I found is after I restored the database from another server to new server, I restored the encryption key, and after that we renamed the new computer to the old computer name, and then I don't need to restore the encryption key it still works.