Microsoft Reporting Services 2019, MS SQL 2019 - Authentication with the Report Server

Question

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An unknown error has occurred in the WMI Provider. Error Code 80131500

 ---> System.Exception: Exception of type 'System.Exception' was thrown.
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.SavePowerBIInformation(String clientId, String clientSecret, String appObjectId, String tenantName, String tenantId, String resourceUrl, String authUrl, String tokenUrl, String redirectUrls)
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SavePowerBIInformation(PowerBIAppConfiguration appConfig)

The report server was unable to validate the integrity of encrypted data in the database. (rsCannotValidateEncryptedData) Get Online Help

permissions, WMIProviderException, rsCannotValidateEncryptedData, Authentication, Role Assignments

Keyset does not exist (Exception from HRESULT: 0x80090016)

Service account

Use built in acount

An error has occurred.

You do not have permission for this operation. Contact your administrator to obtain the necessary permissions.

rsAccessedDenied - Reporting Services Error

Use another account (Account Domain\user)

Cannot start report server.

Research

https://learn.microsoft.com/en-us/sql/reporting-services/security/grant-user-access-to-a-report-server?view=sql-server-ver16

Stack Overflow, many solutions offered mention IE. IE is no longer supported.

The web portal of a report server (SSRS Native Mode) https://learn.microsoft.com/en-us/sql/reporting-services/web-portal-ssrs-native-mode?view=sql-server-ver16

My question is HOW do you create an account to grant FULL admin rights?

I'm using an account with full admin rights on the Windows 11 PC, to set up the SQL server. Report server I cannot use the domain account as the service will not start.

I've spent well over a day attempting to find a solution.

Attempting to register Power BI Service is again impossible.

Answer 1

Hi @CHRISTOPHER BIRD

Your description is a bit confusing. Did you encounter an error when configuring the newly installed SSRS? Or have some operations been performed that caused errors in SSRS that was originally running normally? I noticed you mentioned signing up for the Power BI service. Is this error on the SSRS side or on the Power BI side?

According to the search, most of the errors that appear "The report server cannot verify the integrity of the encrypted data in the database" are due to the encryption key. You can refer to this thread: https://stackoverflow.com/questions/46203955/the-report-server-was-unable-to-validate-the-integrity-of-encrypted-data.

Regarding getting this error when registering Power BI, I found this similar thread for you: https://community.fabric.microsoft.com/t5/Service/sql-server-2016-reporting-services-configuration-manager-power/m-p/28021. For more questions about Power BI, you can seek help in the Power BI forum: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi.

If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

Best regards,

Aniya