Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
dsmudge35
Frequent Visitor

Power BI Report Server(Sep 18) install problem for remote Report Server db's

Hi, the setup is- 

 

- SERVER A with PowerBI Report server installed (No Database engine)

- SERVER B with SQL2016 SP2 Database engine. 

 

When running through the Report Server config mgr on SERVER A and entering details of SERVER B, at the end of the wizard it comes up with following 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.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.GenerateDatabaseScript(String databaseName, Int32 lcid, Boolean isSharePointIntegrated, String& script)

 

This is baffling me, I found some other posts of similiar nature and dont look to have been resolved.   The PowerBI Report server service is running under a Domain Account which has been given system admin permissions on SERVER B and is the local admin grp on SERVER B.  

 

 

On Server A I have executed rpcping command to SERVER B and get a response which implies RPC is contactable.  I have also temporary turned off the Windows Firewall on both SERVERS as well. 

 

I'm struggling to establish what else to check. 

 

Thanks

 

 

1 REPLY 1
bradsy
Microsoft Employee
Microsoft Employee

Looking in the code, I do not see a specific reason this would happen. I have run into similar things before, here is what I would try.

 

1. The config tool is version specific. Make sure you are using the PBI Sept config tool.

2. Make sure the PowerBIReportServer service is running.

3. Make sure WMI service is running on both machines.

4. Turn off firewall (you did this, so that is not the issue).

5. Make sure the ReportingServicesService.exe is running (this is the windows service mentioned in the call stack).

6. SQL default used to block certain types of connections. If so, run the SQL Configuration tool and allow connections.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.