Backup Report Service Encryption Keys - SQL-FineBuild/Common GitHub Wiki

Previous Setup HTTP Reservation Security Manual Configuration Setup Report Service Administration Accounts Next

FineBuild can backup the encryption keys used by the Report Service. This applies to both SSRS and PowerBI Server.

Report 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 Report Service Encryption Keys

The Backup Report Service Encryption Keys processing relates to Process Id 4RAK. If the Report Service is installed along with the Report Service database, the Backup Report Service Encryption Keys processing will always be performed.

FineBuild also uses the following parameters to help perform the Backup Report Service Encryption Keys processing:

Parameter Default Value Description
/DirSSQL: SQLFiles High level folder for SQL Server files
/Instance: MSSQLSERVER Name of SQL Instance to be installed
/RSExecPassword: Password for RS Unattended Execution Account
/SAPwd: none Password for sa account
/VolBackup: System Drive Drive for SQL Server backup files

Top

Manual Backup Report Service Encryption Keys

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

  1. Start Report Service Configuration Manager

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

    Click Connect to connect to Report Service and then select Encryption Keys

    Start RS Configuration Manager

  2. Click Backup and enter the following values

    Click OK to make the backup

    Item Comment
    File Location (model) /VolBackup: :\ /DirSQL: \MSSQL. /Instance: .Backup.SystemDataBackup.RSEncryptionKey.snk
    File Location (example) I:\SQLFiles\MSSQL.MSSQLSERVER.Backup.SystemDataBackup.RSEncryptionKey.snk
    Password Use the /RSExecPassword: value if supplied, otherwise use the /SAPwd: value
    Confirm Password repeat value

    Backup Key

  3. Click Exit to close Report Service Configuration Manager

    Close

Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements

Previous Setup HTTP Reservation Security Top Setup Report Service Administration Accounts Next