Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Power BI Report Server Issues with HA and NLB

Hello everyone,   I’ve installed Power BI Reporting Services as a scaled out deployment on two servers with the SSRS DB on a HA Always On Cluster. I’ve used a SSL Certificate for a virtual host nam...
ha
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for your reply.

I’ve checked via urlacl the registrations. I’ve found 3 registrations which pointed on a wrong url. The other one seems to be correct. I deleted the three wrong registrations. But must be the registrations for the ssrs services pointed to the service account? Currently the registrations are made for a local service account …

    Reserved URL            : https://powerbi.<domain>.org:443/ReportServer/

        User: NT SERVICE\PowerBIReportServer

            Listen: Yes

            Delegate: No

            SDDL: D:(A;;GX;;;S-1-5-80-1730998386-2757299892-37364343-1607169425-3512908663)

 

Second Error:

Both Server runs under the same service account. If I stop one of the server, I can use the Portal. So I don’t think that the firewall or something else blocks the request.

The Logfile stored under:

"<DRIVE>:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSPowerBI_<DATETIME>.log"

pbx's avatar
pbx
Icon for Helper V rankHelper V
8 years ago

NT SERVICE\PowerBIReportServer is an internal group that should contain your domain service account, so you should be good there. I think the idea is that if you switch the service account, the URL reservations do not need to change.

 

Let's put the database error aside for now. Based on what you are saying that stopping one server works, there must be some misconfiguration. Let's see if we can find that.

 

First thing would be to provide your URL reservations in the rsreportserver.config file. You don't need to provide the actual urls, but mask them in a way that are consistent.

Second, when you restart the PBIRS service, a few log files are generated. Could you look into those and provide the following info?

 

  1. In the RSPowerBI_YYYY_MM_DD_HH_MI_SS.log, there is one or more lines like this: “|INFO|1|CFG : Hosting-url-ReportServerWebApp = [a url here] (env)”. Can you provide the url?
  2. In the RSPortal_YYYY_MM_DD_HH_MI_SS.log, the is one or more lines like this: “INFO: Web app url: some url binding here”.  What does that look like?
  3. In the ReportingServicesService_YYYY_MM_DD_HH_MI_SS.log, there are three lines like below:
    • INFO: Using report server internal url  <a url here>.
    • INFO: Using report server external url <a url here>.
    • INFO: Using url root <a url here>.

By the way, how confident are you in performance of the Windows NLB? How do you know if that is not acting up?