omkarclouddba.tech

How to resolve Report server URL was not working? | Fix rsCannotValidateEncryptedData error

This Article help ,

How to resolve Report server URL was not working? or Fix rsCannotValidateEncryptedData error

How to resolve Report server URL was not working?

What is SSRS?

SQL Server Reporting Services are getting used to create various type of reports from database or data warehouse. This reports are useful to identify various trends, business metrics etc. This reports can be accessed from SQL server reporting configuration Manager.

SSRS enables users to design and generate reports from various data sources, such as relational databases, multidimensional databases, and other data formats. It provides a wide range of features for report authoring, data visualization, and report delivery.

What is error Fix rsCannotValidateEncryptedData error or Report server URL was not working?

Sometime you will try to access reporting URL from Reporting configuration Manager but we get this error. There are many possibilities of these errors

The error message "rsCannotValidateEncryptedData" commonly occurs within SQL Server Reporting Services (SSRS). This error pertains to the validation of encrypted data within the SSRS configuration.

Microsoft.ReportingServices.WmiProvider.WMIProviderException: The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData)

   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)

   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.DeleteEncryptedInformation()

   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()

SSRS employs encryption to safeguard sensitive information, such as credentials, connection strings, and encryption keys. However, encountering issues during the encryption or decryption process can trigger the “rsCannotValidateEncryptedData” error.

Here are several potential causes and solutions for this error:

  1. Configuration file corruption: Corruption within the configuration files utilized by SSRS may be responsible. In such cases, regenerating the encryption keys via the Reporting Services Configuration Manager tool can be attempted. By navigating to the “Encryption Keys” section, selecting “Delete” to remove existing keys, and then clicking on “Generate Keys,” new encryption keys can be created.
  2. Invalid encryption key password: This error may arise if an incorrect password is provided for the encryption key during the startup of the SSRS service. Ensuring the accurate input of the encryption key password during service startup is crucial.
  3. Database connectivity issues: Network problems, incorrect credentials, or database server issues can impede SSRS from establishing a connection with the underlying database. It is essential to verify the accuracy and functionality of the database connection settings within the SSRS configuration.
  4. Upgraded SSRS version: If an upgrade to a new version of SSRS has recently taken place, compatibility issues may arise with the encrypted data from the previous version. In such instances, decrypting and re-encrypting sensitive data using the new SSRS version may be necessary.
  5. Permissions and access issues: Ensuring that the service account running the SSRS service possesses the required permissions to access and decrypt the encrypted data is vital. Reviewing the permissions on the encryption keys and the folders containing the SSRS configuration files is recommended

How to resolve this error?

To Resolve this perform below steps

--Run below SP on Report Server Database
exec DeleteEncryptedContent

--Restart SQL Server Reporting Service from SQL Server configuration Manager
Exit mobile version