We help IT Professionals succeed at work.

Minimum rights to deply SSRS

rwheeler23
rwheeler23 asked
on
523 Views
Last Modified: 2012-05-06
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.
Comment
Watch Question

Chris LuttrellSenior Database Architect
CERTIFIED EXPERT

Commented:
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
rwheeler23President

Author

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.
Chris LuttrellSenior Database Architect
CERTIFIED EXPERT

Commented:
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?
rwheeler23President

Author

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

Author

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?
Senior Database Architect
CERTIFIED EXPERT
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
rwheeler23President

Author

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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.