M
M
MoyMirok2021-06-01 17:19:23
SQL Server
MoyMirok, 2021-06-01 17:19:23

SSRS problem during deployment, any ideas?

There is a problem when deploying from the 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_MON22SQL 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 they did: Deleted encryption

keys
Me DB
Changed users to connect.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question