SCCM - Access to some reports not working

Steve 6 Reputation points
2021-10-05T18:49:02.523+00:00

Hi,

I'm trying to give access to two users to 1 specific report OS>Computers with a specific operating system
i tried multiple ways by AD security group to manually adding the user to the report properties - security..... still not working
the results are either the user gets all access to all reports or nothing access denied.

please help.

thanks,

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,793 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Steve 6 Reputation points
    2021-10-11T19:53:23.753+00:00

    Ok, so I added them in the Administrative Users section // created a role under Security Roles // added them to that role// I notice that the permissions take time to push, so wait for that.
    but thanks for the help.

    1 person found this answer helpful.
  2. Joyzhao-MSFT 15,566 Reputation points
    2021-10-06T06:09:34.933+00:00

    Hi @Steve ,
    What permissions have you set for users?
    Scope defines the boundaries within which roles are used. Item-level roles provide varying levels of access to report server items and operations that affect those items. Item-level roles are defined on the root node (Home) and all items throughout the report server folder hierarchy. System-level roles authorize access at the site level.

    Role assignments are inherited within the folder hierarchy and are automatically inherited by contained:

    • Reports
    • Shared data sources
    • Resources
    • Subfolders

    Role-based security in Reporting Services is organized into the following levels:

    • Item-level role assignments control access to items in the report server folder hierarchy such as:
      reports
      folders
      report models
      shared data sources
      other resources
    • Item-level role assignments are defined when create a role assignment on a specific item, or on the Home folder.
    • System role assignments authorize operations that are scoped to the server as a whole. For example, the ability to manage jobs is a system level operation. A system role assignment isn't the equivalent of a system administrator. It doesn't confer advanced permissions that grant full control of a report server.

    A system role assignment doesn't authorize access to items in the folder hierarchy. System and item security are mutually exclusive. Sometimes, you might need to create both a system-level and item-level role assignment to provide sufficient access for a user or group.

    For more information,please refer to: Role Definitions. Role Assignments.
    Best Regards,
    Joy

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.