Share via

Tutorial: Setting Permissions in Reporting Services

New: 17 July 2006

Reporting Services uses roles and role assignments to control access to report server content. By creating role assignments, you enable other users in your organization to view and publish reports and other items on a report server.

There are two categories of roles: system-level and item-level. System-level role assignments specify a collection of tasks that apply to the report server site as a whole. Item-level role assignments describe tasks that apply to content, including permissions for publishing reports, generating models, viewing reports, setting properties, creating subscriptions, and so on. System-level and item-level role assignments are used together to provide a comprehensive set of permissions; even users who require limited access to a report server will benefit from having a system-level role assignment.

What You Will Learn

This tutorial will teach you how to use Management Studio to define role assignments that grant access to report server content.

This tutorial assumes that you are a local administrator, configuring report server access on a new installation for the users in your organization. Reporting Services uses Windows authentication by default. If you are using forms authentication instead of Windows authentication, specify group or user accounts that are valid for the custom authentication extension that is deployed on your report server.

This tutorial is divided into three lessons:


This tutorial uses Management Studio to create role assignments. You can also use Report Manager to accomplish the same task. For more information, see How to: Create, Delete, or Modify a System Role Assignment (Report Manager).


This tutorial requires that you know how to use SQL Server Management Studio and Report Manager. For more information about how to find these tools, see Tutorial: Reporting Services Tools.

The report server must be running in native mode.

You must have administrator permissions on the local computer.

You must have installed the AdventureWorks sample reports and sample database, and published the sample reports to a report server. For more information, see Installing Samples and AdventureWorks Report Samples.

Estimated time to complete the tutorial: 30 minutes.


When reviewing tutorials we recommend that you add the Next and Previous buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

See Also


SQL Server Management Studio Tutorial

Other Resources

Deployment Modes for Reporting Services
Report Manager
Installing Samples
Managing Permissions and Security for Reporting Services
Predefined Role Assignments

Help and Information

Getting SQL Server 2005 Assistance