Forum Discussion
Power BI report server configuration error
I have recently installed a Power BI report server, While I am configuring Database in Report server Configuration Manager I get the 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)
From SSMS I can connect to the SQL server and create a database.
Any help in fixing this issue is appreciated.
Thanks
6 Replies
Hi Ravzz,
Did you install the latest Power BI report server version 14.0.600.438?
From the error message, it seems there is permission issue. Did you create the report server database on a remote computer? If it is, please use a domain user account or a service account that has network access. Also please check if the database server meet the requirements firstly. For more information, see: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-report-server-database
Best Regards,
Qiuyun YuThanks for your reply v-qiuyu-msft
I have tried creating database on the same server which is running 2014 Developer edition and I have tried on remote server which is running on 2016 Enterprise edition, on both the servers I had the same issue. Connection is fine as I could you able to do a test connection and login from ssms. Don't know what else to do?
Thanks,
Rav
Hi Ravzz,
Please open log files (C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles) around the time error occurs, check if there are any detail error message.
Best Regards,
Qiuyun Yu
I had the same issue. My workaround was to download and install SSRS 2017 (https://www.microsoft.com/en-us/download/details.aspx?id=55252), uninstall SSRS 2017 then re-install PowerBI server.
Go through each step of the SSRS setup (I installed the DEV edition for both SSRS and PowerBI). Establish the service account, web service URL, database and web portal URL. Then uninstall SSRS. NOTE: I changed the default values for the virtual directories and database name so I could use the default settings in the PowerBI server setup.
Hope this helps.
I had the same issues. This solution worked for me!
