This project has moved. For the latest updates, please go here.

Previous Configure Reporting Services Unattended Execution Account Manual Configuration Configure Reporting Services IIS Alias Next

Backup Reporting Services Encryption Keys

FineBuild can backup the encryption keys used by Reporting Services.

Reporting services uses encryption keys to secure credentials and connection information. A backup should be taken of these keys in case the information is needed for troubleshooting purposes.

FineBuild Backup Reporting Services Encryption Keys

The Backup Reporting Services Encryption Keys processing relates to Process Id 5CHC. If Reporting Services is installed along with the Report Services database, the Backup Reporting Services Encryption Keys processing will always be performed.

FineBuild also uses the following parameters to help perform the Backup Reporting Services Encryption Keys processing:
Parameter Default Value Description
DrvBackup System Drive Drive for SQL Server backup files
DirSSQL SQLFiles High level folder for SQL Server files
Instance MSSQLSERVER Name of SQL Instance to be installed
SAPwd none Password for sa account

Top

Manual Backup Reporting Services Encryption Keys

The following steps show what you would have to do for manual Backup Reporting Services Encryption Keys processing. FineBuild does all of this work for you automatically.

1) Start Reporting Services Configuration Manager.

This can be done by navigating to Start Menu -> Microsoft SQL Server -> Configuration Tools -> Reporting Services Configuration Manager.

Click Connect to connect to Reporting Services and then select Encryption Keys.
RSConnect.png
2) Click Backup and enter the following values. Then click OK to make the backup.
File Location (model) DrvBackup:\DirSQL\MSSQL.Instance.Backup.SystemDataBackup.RSEncryptionKey.snk
File Location (example) I:\SQLFiles\MSSQL.MSSQLSERVER.Backup.SystemDataBackup.RSEncryptionKey.snk
Password SAPwd value
Confirm Password SAPwd value

BackupKey.png
3) Click Exit to close Reporting services Configuration Manager.
SaveConfig.png

Copyright FineBuild Team © 2013 - 2015. License and Acknowledgements
Previous Configure Reporting Services Unattended Execution Account Top Configure Reporting Services IIS Alias Next

Last edited Jul 8, 2015 at 10:55 AM by EdVassie, version 5