Forum Discussion
401.2 Access denied when testing the ReportServer URL as a regular windows user
Hello,
We are having an issue where we cannot access the ReportServer URL from any client unless the user is in the Computername\Administrators group on the report server itself. Could this have something to do with a User Rights assignment or possibly the URL Reservertaion and the user attached to it? The problem is that this means none of our regular users can run a paginated report.
Thanks,
Dy
13 Replies
Hi, Dycacian
Yes, It does need to assign permissions to view the report directly through the url. You can create or modify a system role definition in the security of the site settings. You can also assign role-based security in the security of home page management.
Reference:Grant user access to a report server - SQL Server Reporting Services (SSRS) | Microsoft Docs
If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-janeyg-msft, thank you for the response!
The user in question has every possible permission I could give within the Report Server Portal. So they do have access to everything they need. But they still can't run a paginated report or access the HTTP://hostname/ReportServer URL without <Builtin> Administrator group access on the server hosting the PowerBI Report Server service.
Thanks,
Dy
Hi, Dycacian
'But they still can't run a paginated report or access the HTTP://hostname/ReportServer URL without <Builtin> Administrator group access on the server hosting the PowerBI Report Server service. '
Since I don't have premium capacity and cannot use pagination reports, it is difficult to reproduce your problem.
Are you talking about web portal url? Do you mean that users can view reports but can't view paginated reports after setting permissions for users? Is the data source connection of the pagination report normal?
Best Regards
Janey Guo
