I have a SharePoint performance point site which also hosts reporting services reports
Sometimes users cannot view these reporting service reports and they see a generic reports error (screenshots below).
Within the reports server the user access is granted up by adding an active directory group which contains the users id and then granted 'User' privileges to the reports.
When the issue occurs, I can temporarily resolve it by adding the users id directly to the reports server security page (outside the AD user group) with 'User' access and they can then view the reports without error.
The strange thing is that if i then remove the users id straight away and leave the original AD group to authenticate they can still view the reports without error ... its as if the reports server security just needs to be refreshed ?
Any ideas suggestions on cause or how to resolve permanently ?
When viewing http://ServerName/Reports I see the below message
And when viewing When viewing http://ServerName/ReportServer I see the below message
Which version of
operating system client use? If it is later version since Windows Vista/Server 2008, it
might be caused by UAC configuration. As we may know, when UAC is enabled and we access the report server site, we may get the error said the user has insufficient privilege to access the report server. For the explorer now runs with the least user privileges.
Currently, we have two workarounds. Please try to disable the UAC, or assign the user permissions in SSRS individually.