SSRS Data Source is not responding error as The report server is unable to access encrypted data

The report server is unable to access encrypted data

Issue:

As we all know we have to plan for Disaster Recovery (DR) for our SharePoint environment we do a trail run on every year. We have performed the DR for this year also but during the practice we have encountered the below error while rendering SSRS reports. The error coming was: The report server is unable to access encrypted data.

The report server is unable to access encrypted data
The report server is unable to access encrypted data

Why is this issue?



We have restored all the below set of application DB from PROD to DR server and it has overwritten the reporting service DB also.

  • UserProfileService_ProfileDB
  • UserProfileService_SocialDB
  • UserProfileService_SyncDB
  • ReportingService
  • ReportingService_Alerting
  • ReportingServiceTempDB
  • SearchService_Admin
  • SearchService_Admin_AnalyticsReportingStore
  • SearchService_Admin_CrawlStore
  • SearchService_Admin_LinksStore
  • SecureStoreService

The issue here is PROD FARM has configured with one security key and DR server got configured with some other security key.

Solution:

Create all the data sources in DR server to fix this issue. As soon as we create the new data source for SSRS report everything went seamlessly.

Hope this helps.

Similar SharePoint 2013 Tutorials


Leave a Reply