Topic Last Updated—August 2008

SQL Reporting Services in Configuration Manager 2007 R2 uses role-based authorization and Windows authentication to determine which users can perform operations and access items on a report server. Role-based authorization categorizes into roles the actions that a user or group can perform.

The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.

Security roles in SQL Reporting Services

To use SQL Reporting Services, a user must be assigned to one or more of the following roles:

The minimum role required to run SQL reports is My Reports.
  • Browser Can view folders, view reports, and subscribe to reports.

  • Content Manager Can manage content on the report server, such as folders and reports.

  • Model Item Browser Can view reporting services models.

  • My Reports Can publish reports and manage folders and reports only in the user’s own folder.

  • Publisher Can publish reports and linked reports to the report server.

  • Report Builder Can view report definitions.

  • System Administrator Can view and modify system role assignments, system role definitions, system properties, and shared schedules.

  • System User Can view system properties and shared schedules.

See Also