Restore the SSRS Encryption Key

Procedure 9 of 23 associated with Step 2 - Change the Computer Name, Domain, or Workgroup of an Individual Managed server.

Perform this procedure only if you are changing the name of the computer running SQL Server that hosts the Reporting Services Server role in the Data Center that provides reporting services for Workforce Management (WFM), Scorecards, eLearning, Coaching, Customer Feedback, Interactions and Speech Analytics products. database. Otherwise, skip this procedure and continue to Generate and install new TLS Server Certificates.

In this procedure, you:

  • Restore the SSRS Encryption Key on the server that hosts the Reporting Services database. You restore the Encryption Key that you backed up in the procedure Back up the SSRS Encryption Key.

  • Test the Web Service URL used to access the Report Server. This step verifies connectivity with the Report Server after restoration of the encryption key.

  1. On the computer running SQL Server that hosts the Reporting Services database, open the Reporting Services Configuration Manager.

    Click Start > All Programs > Microsoft SQL Server R2 > Configuration Tools > Reporting Services Configuration Manager.

  2. Click Yes when prompted to allow the program to make changes to this computer.

  3. In the Reporting Services Configuration Connection screen, click Connect to connect to the Report Server Instance that hosts the Reporting Services database.

  4. In the Reporting Services Configuration Manager, click Encryption Keys in the left pane.

  5. In the Restore section, click Restore.

  6. In the Restore Encryption Key screen, do the following:

    1. File Location: - Open the directory in which you stored the Encryption Key backup file, and select the backup file. Click Open.

    2. Password: - Enter the password that you specified to protect the Encryption Key backup from unauthorized access. Click OK.

      You specified the file location and the password for the Encryption Key backup file in the procedure Back up the SSRS Encryption Key.

  7. Test the Web Service URL used to access the Report Server.

    1. Click Web Service URL in the left pane.

    2. Under Report Server Web Service URLs in the right pane, click on the URL.

    3. On the SQL Server Reporting Services - Report Server login page, enter the User Name and Password of the MSA and click Logon. Verify that the connection to the Report Server is successful.

  8. Click Exit.

What to do next 

Generate and install new TLS Server Certificates