none
WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point

    Question

  • I am getting the following error message while trying to configure a database for a Reporting Service Server.  Both SQL Server and Reporting server are 2012 named instances.  I have 2014 instances as well on the same server.

    Exception details...

    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 (0x800706B3): 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.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)
       at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)

    Can someone help me on this please?

    Friday, August 01, 2014 7:10 PM

Answers

  • Thanks Simon for your Answer. 

    I had checked both and there was no specific issue with it.  I have sysadmin permissions on the server.

    Since time was critical and the servers were new, I removed all SQL instances (2014 and 2012).  Reinstalled SQL 2012 edition only.  This time it worked.  It should have been an issue with the installation it seems.

    Regards,

    Jaigi

    Monday, August 11, 2014 7:43 AM

All replies

  • Hi Jaigi,

    According to your description, you want to change a report server database for Reporting Services. But it fails on the last step and returns a error. Right?

    In this scenario, it seems you are creating a report server database on another server via remote connection. Based on the error message, it has issues on executing the script for generating new database. Please check if you have permission to connect the server and create a new database. Also please check if the Reporting Services Windows services is working properly.

    If you have any question, please feel free to ask.

    Best Regards,
    Simon Hou

    Wednesday, August 06, 2014 7:24 AM
    Moderator
  • Thanks Simon for your Answer. 

    I had checked both and there was no specific issue with it.  I have sysadmin permissions on the server.

    Since time was critical and the servers were new, I removed all SQL instances (2014 and 2012).  Reinstalled SQL 2012 edition only.  This time it worked.  It should have been an issue with the installation it seems.

    Regards,

    Jaigi

    Monday, August 11, 2014 7:43 AM