SSRS Permisions

Posted on 2011-10-02
Last Modified: 2012-08-13
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?
Question by:red_75116
    1 Comment
    LVL 10

    Accepted Solution

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Suggested Solutions

    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now