Monday, November 25, 2013

ReportServer: Procedure to Backup the Encryption Keys

We would needing to backup the Encryption Keys used in Reporting Services for various purpose. Below mentioned are the simple steps to backup you current Encryption Keys. Note that the reporting services should be running to backup the Encryption Keys.

Step1: Go to Your Source Server Reporting Services where your Reporting Services are running, Go to Start—> All Programs—>Microsoft SQL Server XXXX(XXXX is your Microsoft SQL Server Version)—>Configuration Tools—>Reporting Services Configuration Manager. The Below Screen Appears. Enter the ServerName and Report Server Instance(MSSQLSERVER by default) and click connect.


Step2: In Reporting Services Configuration Manager, click on Encryption Keys Tab and click backup to backup your current Encryption Keys .



Ste3: Select a safe location to Store the encryption key, provide a strong password as shown below and click ok and close the Reporting Services Configuration Manager. Make sure you wont forget this password as this password is needed if you want to restore this encryption key back. This encryption key holds all credentials required for reports, subscriptions etc.



Done, You have backed up your Encryption keys. You can now use this to Restore.

No comments:

Post a Comment