Forum Discussion
401.2 Access denied when testing the ReportServer URL as a regular windows user
Community SupportHi, 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
- v-janeyg-msft
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
The issue is specifically related to the ReportServer webservice service. The portal access is fine. I don't think it is the data source because I am getting an access denied error from the internal Webserver within Power BI Server.
Thanks,
Dy
