asked on

Minimum rights to deply SSRS

What are the minimum roles that must be assigned to a domain user in SQL to allow that user to deploy new reports in SSRS 2005? I keep getting the message "The permissions granted are insufficient to perform this operation" whenever I try to deploy the report.

Chris Luttrell

SSRS Secruity is handled in its own configuration. I have just finished writing up a quick description of how to assign user permissions, see if it helps you.
SSRS-Permissions.doc

rwheeler23

ASKER

I do not what their admin has done but when I go to the home page and click Show Details I see the Delete and Move button but there is no Add New Role button. I am logged into the server as the domain admin. I never can get to the Security screen.

Chris Luttrell

You cannot see the Properties tab like in my diagram? You say you are the domain admin, has someone removed "yourDomain\Domain Adminis" from the Administrators Group on that machine?

rwheeler23

ASKER

This is all I get. I checked the local domain admin group and the domain admin is in there.
Euchner.jpg

rwheeler23

ASKER

It looks like someone has gone to the properties page and deleted all of the roles and users. If that is so, is there any way to get that back and start over?

ASKER CERTIFIED SOLUTION

Chris Luttrell

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

rwheeler23

ASKER

That appears to be the consensus. I am going to check this.

A)      SQL database role, which is:
a.      RSExecRole be sure to grant this to your admin user
B)      Reporting Services roles (stored in the ReportServer database)
a.      You can check on or manipulate these with T-SQL code by joining across these tables:
i.      Users
ii.      Roles
iii.      Policies
iv.      PolicyUserRole