Share via

SQL Server Reporting Services Permissions Issue

Benas Kazlauskas 0 Reputation points
2025-02-10T07:22:58.52+00:00

I'm having a bit of an issue with SSRS permissions. Users (Operations Manager Report Operators) can access files if accessed directly for eg. localhost/reports/browse/folder/AD%20Audit%20Events but if we go to localhost/reports/browse/folder/:

Could not load folder contents You are not allowed to view this folder. Contact your administrator to obtain the necessary permissions.

Now I re-created the security groups, tried custom security settings with and without parent settings, new profile on SCOM and it just seems to be this odd issue where the reports itself are accessible, but the FOLDERS are not..?

If I put the use onto the Operations Manager Administrators, the portal works as intended.

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,528 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,472 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,993 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Martinez 20 Reputation points
    2025-02-11T15:45:08.9433333+00:00

    It sounds like you are experiencing a permissions issue specifically related to folder access in SQL Server Reporting Services (SSRS). In SSRS, permissions can be quite granular, and it's not uncommon to encounter situations where users can access reports directly but are restricted from accessing the folders that contain those reports.

    Here are some steps you can take to troubleshoot and resolve the issue:

    1. Check Folder Permissions
    • Navigate to the Folder: In the SSRS web portal, navigate to the folder that contains the reports.
    • Folder Security Settings: Right-click on the folder and select "Manage" or "Properties" (depending on your SSRS version). Look for the "Security" tab.
    • Review Permissions: Ensure that the Operations Manager Report Operators group has at least "Browser" permissions for the folder. If they do not, add them and ensure that the permissions are inherited from the parent if that is your desired configuration.
    1. Verify Group Membership
    • Check Group Membership: Ensure that the users who are having issues are indeed members of the Operations Manager Report Operators group. Sometimes, there may be a delay in permission propagation or a user might not be properly added to the group.
    1. Review Parent Folder Permissions
    • Check Parent Folder: If the folder is nested within another folder, make sure to check the permissions on the parent folder as well. Sometimes permissions need to be set at multiple levels.
    1. Review SSRS Logs
    • Check SSRS Logs: Review the SSRS log files for any errors or warnings that may give more context on why the permissions are being denied. The log files are usually located in the LogFiles directory of your SSRS installation, often found at C:\Program Files\Microsoft SQL Server\MSRSXX.MSSQLSERVER\Reporting Services\LogFiles.
    1. Restart SSRS Service
    • Restart the Service: Sometimes, a simple restart of the SSRS service can resolve permission issues due to caching.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.