Updated: May 31, 2016
Applies To: SQL Server 2016
Reporting Services uses encryption keys to secure credentials and connection information that is stored in a report server database. In Reporting Services, encryption is supported through a combination of public, private, and symmetric keys that are used to protect sensitive data. The symmetric key is created during report server initialization when you install or configure the report server, and it is used by the report server to encrypt sensitive data that is stored in the report server. Public and private keys are created by the operating system, and they are used to protect the symmetric key. A public and private key pair is created for each report server instance that stores sensitive data in a report server database.
Managing the encryption keys consists of creating a backup copy of the symmetric key, and knowing when and how to restore, delete, or change the keys. If you migrate a report server installation or configure a scale-out deployment, you must have a backup copy of the symmetric key so that you can apply it to the new installation.
To manage symmetric keys, you can use the Reporting Services Configuration tool or the rskeymgmt utility. The tools included in Reporting Services are used to manage the symmetric key only (the public and private keys are managed by the operating system). Both the Reporting Services Configuration tool and the rskeymgmt utility support the following tasks:
Back up a copy of the symmetric key so that you can use it to recover a report server installation or as part of a planned migration.
Restore a previously saved symmetric key to a report server database, allowing a new report server instance to access existing data that it did not originally encrypt.
Delete the encrypted data in a report server database in the unlikely event that you can no longer access encrypted data.
Re-create symmetric keys and re-encrypt data in the unlikely event that the symmetric key is compromised. As a security best practice, you should recreate the symmetric key periodically (for example, every few months) to protect the report server database from cyber attacks that attempt to decipher the key.
Add or remove a report server instance from a report server scale-out deployment where multiple report servers share both a single report server database and the symmetric key that provides reversible encryption for that database.
Initialize a Report Server (SSRS Configuration Manager)
Explains how encryption keys are created.
Back Up and Restore Reporting Services Encryption Keys
Explains how to back up encryption keys and restore them to recover or migrate a report server installation.
Store Encrypted Report Server Data (SSRS Configuration Manager)
Describes encryption on a report server.
Delete and Re-create Encryption Keys (SSRS Configuration Manager)
Explains how you can replace a symmetric key with a new version, and how to start over if symmetric keys cannot be validated.
Add and Remove Encryption Keys for Scale-Out Deployment (SSRS Configuration Manager)
Explains how to add and remove encryption keys to control which report servers are part of a scale-out deployment.