none
Privilege and roles for team members to deploy reports on the SSRS Report Server

    Question

  • My company has the following sql server and ssrs set up.

    Server1: MS SQL Server 2008 R2 installed with a named instance that hosts around 10 databases on the instance. There are two databases -"HDB1" and "HDB2" for our HR division and a group of users(HR Team members) who have ("public" role) access just to these two databases . "HRUserAdmin" is the account that has admin privilege for these two databases.
    Server2: Has MS SQL Server 2008 R2 installed using a default instance. The SSIS and SSRS are configured on this machine. The reportserver database and reportserver tempdb are hosted on this machine. We use the windows authentication option in order to connect to the databases on both the servers.
    I have admin privilege on both the windows and sql server databases. I could successfully deploy a report using BIDS on to the report server and view the report. My question is, If I want the HR Team members to deploy their reports on to report server, what privilege/permission should I grant other than providing the web service URL? would they be able to successfully deploy reports on the report server?

    Monday, September 23, 2013 3:45 AM

Answers

All replies