Forum Discussion

Dycacian's avatar
Dycacian
New Member
5 years ago

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 so...
ReportServer
ReportServerURL
Dycacian's avatar
Dycacian
New Member
5 years ago

v-janeyg-msft ,

Hopefully, this time the image will upload.  Below is what it looks like when we try to load a report when a user is not an administrator of the local server.

 

 

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Dycacian 

 

What's your data source? It doesn't seem to be a report server permission issue. Have you tried to distribute other paginated reports? Try to check whether the paginated report of common data source can be viewed normally.

I search this: Troubleshooting: Server Error in '-' Application. Access Denied - Dynamics NAV | Microsoft Docs

 

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.

  • Dycacian's avatar
    Dycacian
    New Member
    5 years ago

    v-janeyg-msft ,

    Our data source is an Analysis server.  I will check this out, but it doesn't account for the fact that everything works great if the user is a local administrator of the server.  I would think that if it was an authentication setting that it would affect both Admins and users.  

     

    It might be a few days, as I don't have access to the server at this time.  

     

    Thanks,

    Peter

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Dycacian 

     

    In the powerbi service, the data source of AS must map user name to let users see the content, so in the same way, in the report server, it also needs to be configured.

    You can install Power BI Report Server, SQL Server and Analysis Services on a single machine and everything should work without additional configuration. This is great for a test environment. You may hit errors if you have these services installed on separate machines which is called a distributed environment. In this environment, you are required to use Kerberos authentication. There is configuration required to implement this.

    In addition to the attempt to troubleshoot the problem I mentioned in the last reply, you can also check this:Configure Kerberos to use Power BI reports - Power BI | Microsoft Docs

    Hope to get feedback on the progress of your problem.

    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.