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

CharlieLor 551 Reputation points
2021-05-10T21:06:09.8+00:00

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.

95422-image.png

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

95394-image.png

In the Event Log, I also see these errors.

95278-image.png

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!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,607 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,787 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
488 questions

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alexandre Azevedo Filho 5 Reputation points
    2023-04-04T20:35:43.92+00:00

    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!

    1 person found this answer helpful.
    0 comments
  2. Joyzhao-MSFT 15,561 Reputation points
    2021-05-11T06:11:09.24+00:00

    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.

  3. CharlieLor 551 Reputation points
    2021-05-11T17:41:21.107+00:00

    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.

    95683-image.png

  4. CharlieLor 551 Reputation points
    2021-05-11T18:04:15.977+00:00

    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

    0 comments
  5. CharlieLor 551 Reputation points
    2021-05-11T19:13:02.367+00:00

    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()

    95610-image.png