F5 Debug…

Building & Debugging the Technology!!!

Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server

Posted by Karthikeyan Anbarasan on December 13, 2011


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
  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

Hope this article will be useful and if you like, you can follow me in one of the ways below to get update of posts on the latest technology
Twitter @ http://twitter.com/f5Debug
Facebook Page @ http://www.facebook.com/profile.php?id=100002468858656
Linked In @ http://www.linkedin.com/pub/karthikeyan-anbarasan/1b/78b/9a4
Google + @ https://plus.google.com/117525632086880345410/posts
RSS Feed @ http://feeds.feedburner.com/f5debug/Karthik

2 Responses to “Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server”

  1. [...] Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server (Karthikeyan Anbarasan) [...]

  2. [...] Getting Started with SSRS – Part 7 – User Roles and Permissions in SSRS Server [...]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Connecting to %s