Dynamics Search Engine

Saturday, August 15, 2009

How to grant User Access to a SSRS Report Server (Report Manager)

How to grant User Access to a SSRS Report Server (Report Manager)

This article describes:
  • How to give access of report server (report manager) to user or grant user access to a report server (report manager).
  • How to get solution for SSRS report access denied exception / error in Microsoft Dynamics Ax 2009 Role Center (Enterprise Portal).
  • How to solve the insufficient permission exception as shown below:

Applied on: SQL Server 2005 SP2 and Microsoft Dynamics Ax 2009 SP1.

Reporting Services use role-based security to grant user access to a report server. On a new report server installation, only users who are members of the local Administrators group have permissions to report server content and operations. To make the report server available to other users, you have to create role assignments that map user or group accounts to a predefined role that specifies a collection of tasks.



To add a user or group to a system role

1. Start Report Manager.

2. Click Site Settings.


3. Click Security.

4. Click New Role Assignment.


5. In Group or user, enter a Windows domain user or group account in this format: [domain name]\[account]. If you are using forms authentication or custom security, specify the user or group account in the format that is correct for your deployment.


6. Select a system role, and then click OK.


If you select both System Administrator and System User, a user or group will be able to perform the tasks in both roles.




To add a user or group to an Role

1. Open Report Manager.



2. Click the Properties tab.

3. Click the Security tab.

4. Click New Role Assignment.

5. In Group or user, enter a Windows domain user or group account in this format: [domain]\[account].

6. Select one or more role definitions that describe how the user or group should access the item, and then click OK.


Note: Use at your own risk. There is no warranty on this article.