401 error connecting to SSRS reportmanager

Question

SSRS 2012 SP 4

We set up our SSRS as scale-out with load balance cluster.

Virtual name: MySSRS
Node 1: MySSRS01
Node 2: MySSRS02

We get a 401 error when trying to connect to http://MySSRS02/Reports from outside of MySSRS02. When I remote into http://MySSRS02/Reports while remoted into MySSRS02, I can run reports.

If I am trying to connect to MySSRS/Reports from a computer different from node 1 and 2, I get the 401 error when the load balancer directs to MySSRS02.

Interestingly, I can view ReportServer on MySSRS02. I can connect to the web service and can List all of the items.

We have tried different things (changed the SPN, changed the HostName and RootURI to point to the virtual name). But we are stumped.

Any ideas?

Answer 1

Hi @Russel Loski ，

You can refer to these thread ,hope it help：
details.aspx
configure-a-native-mode-report-server-scale-out-deployment
Best Regards,
Isabella

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

401 Unauthorized, so it's a permission issue.
Are you using the same domain account to logon to SSRS?

Answer 3

The last thing that we did before the server worked was to edit the HOSTS files on both nodes.

https://www.bigresource.com/MS_SQL-Scale-Out-Web-Farm-401-1-Unauthorized-gFyDYFGi.html
MS SQL Server :: Scale Out Web Farm 401.1 - Unauthorized

I'm not sure how relevant this is, the load balancer is a third party load balancer.