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.
rwheeler23Asked:
Who is Participating?
 
Chris LuttrellConnect With a Mentor Senior Database ArchitectCommented:
If you do not have reports or something else that would be lost, it may be easier to uninstall RS and reinstall.  Sorry, I have not seen this situation and a work-around.
0
 
Chris LuttrellSenior Database ArchitectCommented:
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
0
 
rwheeler23Author Commented:
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.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Chris LuttrellSenior Database ArchitectCommented:
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?
0
 
rwheeler23Author Commented:
This is all I get. I checked the local domain admin group and the domain admin is in there.
Euchner.jpg
0
 
rwheeler23Author Commented:
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?
0
 
rwheeler23Author Commented:
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

0
All Courses

From novice to tech pro — start learning today.