-
Notifications
You must be signed in to change notification settings - Fork 10
Backup Report Service Encryption Keys
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.
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 |
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.
-
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
-
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 -
Click Exit to close Report Service Configuration Manager
Copyright FineBuild Team © 2013 - 2021. License and Acknowledgements
Previous Setup HTTP Reservation Security | Top | Setup Report Service Administration Accounts Next |
---|
Key SQL FineBuild Links:
SQL FineBuild supports:
- All SQL Server versions from SQL 2019 through to SQL 2005
- Clustered, Non-Clustered and Core implementations of server operating systems
- Availability and Distributed Availability Groups
- 64-bit and (where relevant) 32-bit versions of Windows
The following Windows versions are supported:
- Windows 2022
- Windows 11
- Windows 2019
- Windows 2016
- Windows 10
- Windows 2012 R2
- Windows 8.1
- Windows 2012
- Windows 8
- Windows 2008 R2
- Windows 7
- Windows 2008
- Windows Vista
- Windows 2003
- Windows XP