How to resolve this "Microsoft.ReportingServices.WmiProvider.WMIProviderException:...." error?

Question

I keep getting this error.

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.  
  
 ---> System.Runtime.InteropServices.COMException: The RPC server is not listening. (Exception from HRESULT: 0x800706B3)  
   --- End of inner exception stack trace ---  
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)  
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ListReportServersInDatabase(String[]& installationIDs, String[]& instanceNames, String[]& machineNames, Boolean[]& isInitialized, Int32& length)  
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ListReportServersInDatabase(RSReportServerInfo[]& serverInfos)  

I'm setting up a remote Report Service that points to a SQL Server 2019 server in another box. I went through the whole process of "Change Database" in the Report Server Configuration Manager. I'm able to connect to the remote SQL Server 2019 Standard Edition fine.

However, when I tried to restore the database encryption keys, I get this error.

In the Event Log, I also see these errors.

I have similar errors to this thread, https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c535ebf3-18a0-430d-9a1a-9184182dd946/ssrs-2017-rc-1-cant-start-up, but the SQL Server I'm running is 2019 Standard not 2017.

Some background information. The Report Server database was migrated from SQL Server 2014 Enterprise Edition to a SQL Server 2019 Standard Edition. Since 2014 allowed more than one instances of Report Service, on SQL Server 2019 we have no choice but to put this RS on another box and connect to the Report Server database remotely. This is where I run into a ton of issues and errors. Any help is much appreciated!

Answer 1

I have faced the same problem recently. In my case, the error would show while creating the database from the Reporting Services Configuration Manager 2019.

The problem was caused because another application was making use of port 8082 which is the default port for reporting services.

the fix was the following:

On the Reporting Services installation folder, go to directory: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\RSHostingService

Then, open file config.json
Notice that the managementURL and listenerURL uses port 8082. I updated both to 8083 (it can be any other port you are sure is not being used).

Then, I ran the commands:

(The first command is just to remove any application that could have been using 8083)
netsh int ipv4 add excludedportrange protocol=tcp startport=8083 numberofports=1

netsh http add urlacl url=http://+:8083/ user="NT SERVICE\SQLServerReportingServices"

Hope this help!

Answer 2

Hi @CharlieLor ,

1. Add local administrator rights to the service account running the SSRS instance
2. Switch the account to local service/local system
3. Start the reporting services and configure.
4. Now change the service account to domain account.

Best Regards,
Joy

---

If the answer 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.

Answer 3

Thanks, Yoyazhao! I got further this time. However, after step 4, I clicked on the Web Server Service URL and after 15 minutes of stalling, the page finally showed this message.

Answer 4

I also keep getting this error below in the C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles\RSManagement_*_**__**.log file.

Error Number:-2,State:0,Class:11
2021-05-11 13:01:13.3116|WARN|13|Symmetric Key Encryption access data is missing or corrupt| RequestID = s_9e875818-00c0-49e9-8d57-1dbb79fd22b1 System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.BIServer.Configuration.Key.KeyRepository.GetEncryptedSymmetricKey(InstallationInfo installationInfo)
at Microsoft.BIServer.Configuration.Key.KeyRepository.ReloadEncryptedSymmetricKey()
at Microsoft.BIServer.Management.WebApi.Controllers.StateController.ReloadEncryptedSymmetricKey(ISqlAccess sqlAccess, Byte[]& encryptedSymmetricKey, DatabaseValidationStatus databaseValidationStatus)
ClientConnectionId:c9759d0b-0a25-4d42-81a5-2b010a6c2ea4
Error Number:-2,State:0,Class:11

Answer 5

And if I tried to delete the database encryption key, I get this error.

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.DeleteEncryptedInformation()
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.DeleteEncryptedInformation()