home

MinistryPlatform

RealmRealm AccountingMinistryPlatformeGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite
RealmRealm AccountingMinistryPlatformeGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite

What would you like to know more about?

Show Contents

thumbnailMinistryPlatform

Backups

SSRS Encryption Key

SQL Server Reporting Services (SSRS) uses encryption to protect sensitive data with an encryption key. The encryption key used by SSRS is separate from the database and must be backed up separately. If you move the ReportServer database you must restore the encryption key before SSRS can function. The encryption key only needs to be backed up once unless you manually change the encryption key or make major changes to the system.

Reporting Services Configuration Manager

  1. Launch the Reporting Services Configuration Manager.
  2. Click Encryption Keys.
  3. Click Backup.
  4. Browse to the appropriate file location.
    Tip: Save a backup of the SSRS encryption key in your Database Backups folder so it gets backed up to alternate media as part of your scheduled nightly job.
  5. Enter a password to be used to restore the key if needed. Enter it again to confirm the password.
  6. Click OK.
MinistryPlatform
portal

Last updated: July 12, 2024