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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.