question

RusselLoski-0634 avatar image
0 Votes"
RusselLoski-0634 asked RusselLoski-0634 answered

401 error connecting to SSRS reportmanager

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?

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Isabellaz-1451 avatar image
1 Vote"
Isabellaz-1451 answered RusselLoski-0634 commented

Hi @RusselLoski-0634

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your help. I think that the teams setting it up had tried to follow the advice in these articles, though they may have missed something.

The problem involved some additional changes.

1 Vote 1 ·
OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered RusselLoski-0634 commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for that. We checked an we were using the same domain login

0 Votes 0 ·
RusselLoski-0634 avatar image
0 Votes"
RusselLoski-0634 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.