ReportServer: Deleting Encryption Key in SQL Server Reporting Services Configuration Manager

Below are the steps to Delete the Encryption Key in SQL Server Reporting Services Configuration.

Before Deleting make sure you have taken a backup of your Current Encryption Keys. Click Here to see the procedure to take a backup if not already.

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 Delete to delete your current Encryption Keys .

Step3. You will get a below Pop Up. Click yes, if you want to delete the Keys,

Close the Reporting Services Configuration Manager and Restart the Reporting Services.

Technorati Tags: Delete Encryption Keys,Report Server

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.

Technorati Tags: Backup Encryption Keys,Reporting Services