Restore SSRS encryption keys

Role creation, log in registration, and role assignments occur when you set the report server database connection through the Reporting Services Configuration tool.

A Reporting Services installation requires that the SQL Server Database Engine instance include the RSExecRole role. If you use alternate approaches (specifically, if you use the rsconfig.exe command prompt utility) to configure the connection, the report server is not in a working state.

Before you begin 

If the server name is changed, update the SSRS credentials. (See Update SSRS credentials for database access

Procedure 

1. Open the Reporting Services Configuration Manager.

2. Select Encryption Keys.

3. Click Restore and then select the rsdbkey.snk file exported from old server.

4. Enter the Password used to lock the key when backing up the SSRS encryption keys.

5. Run this query to remove the source server name from the database on the target reporting server. This prevents a scale-out deployment error being raised.

   DELETE FROM [ReportServer].[dbo].[Keys] WHERE MachineName = <SourceServerName>

Related information 

Backup SSRS: http://technet.microsoft.com/en-us/library/ms155814.aspx

Migrate SSRS: http://msdn.microsoft.com/en-us/library/ms143724(v=sql.110).aspx