This article is a part 7 of series of article on SQL Server Reporting Services. This will help you to get started with SQL Server Reporting Services (SSRS).

1. Getting Started with SSRS – Part 1 – SQL Server Reporting Services Overview and Installing in Windows Server 2008
2. Getting Started with SSRS – Part 2 – Designing a report using Report Wizard
3. Getting Started with SSRS – Part 3 – Designing a report using Report Designer   [more]
4. Getting Started with SSRS – Part 4 – Configuring SQL Server Reporting Services in Windows Server 2008
5. Getting Started with SSRS – Part 5 – Deploying a report to the Server
6. Getting Started with SSRS – Part 6 – Creating Deleting and Moving a folder in SSRS Server
7. Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server
8. Getting Started with SSRS – Part 8 – Show SSRS Report in ASP.NET Web Page
9. Getting Started with SSRS – Part 9 – Creating Matrix Report with inbuilt styles in SSRS
10. Getting Started with SSRS – Part 10 – Creating a Report with Charts and Gauges

Introduction

In this article, we will see how to set user access roles and permissions for a specified user in SQL Server Reporting Services. User permissions in SSRS server is a big challenge for accessing the server for specified users. In this article, we will see how to add a new user role and provide permissions for the user to access particular components of the server reports. Let us see the step-by-step process on how to create user role and permission on the server.

Steps

First, let us step into the Report Manager by accessing the local URL or server URL, http://localhost/reports. With this we can see the user interface as shown in the screen below.

Read More