SSRS Problem: Monitoring failed in Deploying Wizard

Question

Hi! I have a problem

I have a problem with SSRS. All was fine, but after change db in SSRS... In SFb Wizard

PageLoadCount: 3 RoutedEventArgs Handled state: False

Deploying Monitoring Reports... This might take a few minutes.

The Monitoring Database is using SQL instance "s376.company.com\mon22". The data source is using SQL instance "(local)\mon22". The following URL will be used for deployment: https://S376.company.com:443/ReportServer_MON22 SQL Server logon credentials for "company\admin" already exist. Use the existing logon credentials. "[QoEMetrics]" role "[ReportsReadOnlyRole]" has already assigned to "company\admin". "[LcsCDR]" role "[ReportsReadOnlyRole]" has already assigned to "company\admin". Start to deploy reports... System.Web.Services.Protocols.SoapException: The report server was unable to validate the integrity of encrypted data in the database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.CannotValidateEncryptedDataException: The report server was unable to validate the integrity of encrypted data in the database. at Microsoft.ReportingServices.Library.ReportingService2005Impl.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, Property[] SearchOptions, SearchCondition[] Conditions, ServerCompatLevel compatLevel, CatalogItemList& Items) at Microsoft.ReportingServices.WebServer.ReportingService2005.FindItems(String Folder, BooleanOperatorEnum BooleanOperator, SearchCondition[] Conditions, CatalogItem[]& Items) An error occurred when deploying Monitoring Reports. For details, see the log.

What we did:

Remove encription keys

Change DB to Previous

Change users etc... Nothing.

Don't even suggest reading Microsoft guides. First, I read, Second, they do not cover SSRS configuration.

Answer 1

@Viktar Bachkouski ,

Where do you change the database? In SSRS or Skype for Business Wizard?

Do you back up the encryption keys before removing it?

If you have backup, try to recovery the encryption key and change the database to previous one to check if it is fixed.

Meanwhile, in regard of this error message -- The report server was unable to validate the integrity of encrypted data in the database, you could restart the services and try again. Many people discuss this topic here. You could refer to it.

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.