Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

This tutorial will help you to get started with SQL Server Reporting Services (SSRS)

Getting Started with SSRS (SQL Server Reporting Services)

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

Dec 13 2011 12:00AM by Karthikeyan Anbarasan   

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.

Report Manager Launched

Now click on the Site Setting link at the top right corner. This will navigate us to a new window as shown in the screen below. Click on Security link at the left side menu to proceed further.

Properties of the Report Manager

Here we can see BUILTIN\Administrators user assigned to System Administrators role as shown in the screen below.

Security Setting for the New Role

Now let us add a new user to the role. Click on the New Role Assignment menu button as shown in the screen below.

Selecting the New Role Assignment

An admin screen will appear with an option to enter the user name to which we need to assign the role. In addition, we can see the list of roles that can be assigned to the specific user as shown in the screen below.

Properties of the New Role Assignment Creation

Enter the user name, select the roles based on the requirement and click on OK to add the user as shown in the screen below.

Providing the New User to map with the Role

Clicking on OK will take some time to execute and create a user with the permissions. Once the process is completed, we can see the user with the role listed as shown in the screen below.

Newly created user with the roles

Next is to assign the user to the specific role. Go back to Home page and click on properties tab as shown in the screen below.

Selecting the Properties to access the custom roles

Navigating to the Properties tab, we can see the option to add New Role Assignment. Clicking it will navigate the user to the other page with the list roles that can be assigned to the user as shown in the screen below.

List of the Role based security

Now enter the user, select the respective roles, and click on OK as shown in the screen below.

Providing the New User to assign with the group

Click on OK and once the roles are added to the user we can see the list as shown in the screen below.

Newly created user/Group in the list

Conclusion

So in this article we have seen the user and role permission setting for the SSRS server. Role with user permissions are the major thing for an administrator to assign specific roles as per the user requirement to handle the server.


Karthikeyan Anbarasan
52 · 4% · 1176
9



Submit

1  Comments  

  • Hi,

    Normal domain users can not able to access the SSRS reports at the their at desktop pc side.

    Those domain user id - I have addes at local administrators groups in report server then only they can able to access these ssrs reports.

    Please tell me, how can access ssrs reports without add local administrators groups those domain id?

    Thanks ananda

    commented on Dec 14 2011 1:23AM
    Ananda
    1572 · 0% · 13

Your Comment


Sign Up or Login to post a comment.

"Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server" rated 5 out of 5 by 9 readers
Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server , 5.0 out of 5 based on 9 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]