Forum Discussion
PowerBI Report Server - The request failed with HTTP status 401: Unauthorized
I have 2 PowerBI Report Server installed in a scale-out deployment with a network load balancer. I followed the instructions described in https://docs.microsoft.com/en-us/sql/reporting-services/repor...
Hi,
I had that one and I don't remember the exact solution order, but you must make sure that follwing is done
- generate machinekeys and put them in both rsconfig & machine.config. Then restart both nodes
- SSL -Offloading must be done by the loadbalancer e.g. F5. The windows networt balancer would never work. I tried it and had to switch to F5
- the BackConnectionHostNames entries must be existing on both nodes for the servername only, fqdn, ssrs main page
- activate session persistance on the load balancer
You are getting 400 because the loadbalancer directs your request to opposite node from which it has been initiated
BR Bobi
FYI: The place where the machine key should be added to machine.config:
https://stackoverflow.com/questions/10337634/adding-machinekey-to-machine-config/10337791
flopi wrote:Hi,
I had that one and I don't remember the exact solution order, but you must make sure that follwing is done
- generate machinekeys and put them in both rsconfig & machine.config. Then restart both nodes
- SSL -Offloading must be done by the loadbalancer e.g. F5. The windows networt balancer would never work. I tried it and had to switch to F5
- the BackConnectionHostNames entries must be existing on both nodes for the servername only, fqdn, ssrs main page
- activate session persistance on the load balancer
You are getting 400 because the loadbalancer directs your request to opposite node from which it has been initiated
BR Bobi