• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

SSRS Permisions

I have been given a user account to run some SSRS reports, but this account doesn't appear to be a domain admin account.  When I try to go to reportserver url I get this error.

The permissions granted to user 'DOVER\synadmin' are insufficient for performing this operation. (rsAccessDenied)

I have the sa password for the sql server, is it possible to use that account to give this sysadmin the rights necessary to administer SSRS?
0
red_75116
Asked:
red_75116
1 Solution
 
GDG_DBACommented:
You don't need domain admin rights to run SSRS reports.  

Have the administrator of your SSRS server grant you browser permissions on the folder and or report(s) you need access to.  If you need to publish new reports, you will need Content Manager permissions.  If you need to navigate the site to the folder where your reports are, you will need a minimum of View Folder rights along the path.

If the user account provided to run reports is a user in the database, use that account in the DATA SOURCE of the report.  

Let me know if you have further questions.
-G
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now