[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Permissions necessary to access SQL 2008 Reporting Services Configuration Manager

Posted on 2011-10-11
5
Medium Priority
?
391 Views
Last Modified: 2012-05-12
I am wondering if anyone knows what permissions I need to give a user so that they can run SQL Server 2008 Reporting Services Configuration Manager. I know that if I make the user an admin on the server this will work but I would like a less open solution. The user is a SQL admin already as well.

Thanks.
0
Comment
Question by:snowmizer
  • 3
  • 2
5 Comments
 
LVL 40

Expert Comment

by:lcohan
ID: 36951343
I presume your "SQL Admin" is a user member of sysadmin SQL Server Role and that has nothing to do with "SQL Server 2008 Reporting Services Configuration Manager"
As far as I'm aware you must be local admin on the box where SSRS service is installed and will be configured but that's done only once when you install/setup SSRS by an system admin or DBA so I can't see why a user need access to run "SQL Server 2008 Reporting Services Configuration Manager"
0
 

Author Comment

by:snowmizer
ID: 36951639
Local admin was the only thing I could figure as well. I wasn't sure why the user would need to run this now that the server is configured (other than to backup the encryption keys or something like that) if we were moving to a new server. I'll probably leave everything alone and if it becomes an issue then I'll make them a local admin.

Thanks.
0
 
LVL 40

Expert Comment

by:lcohan
ID: 36951691
I suspect the user needs to run the "Report Manager" web site and NOT the SSRS Configuration Manager in which case "Content Manager" role is what they need. Please start SSMS on the SSRS box and connect to "Reporting services" not "Database engine" to see all the defualt SSRS roles and description about each under the security tab - just expand and right click each role to see what a user associated to the Role can do.

Hope this helps.
0
 

Author Comment

by:snowmizer
ID: 36951755
No we were setting up a new server and this user was helping with the setup of Reporting Services and needed to get into "Configuration Manager". The server is set up now so I was just wondering what permissions were necessary to run this in the future.
0
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 36951887
Ah...OK well in that case you need Local Admin at least to run SSRS Configuration Manager:

http://msdn.microsoft.com/en-us/library/ms156305.aspx

[...]
To use the Reporting Services Configuration tool, you must have the following:

Local system administrator permissions on the computer that hosts the report server you want to configure. If you are configuring a remote computer, you must have local system administrator permissions on that computer as well.

You must have permission to create databases on the SQL Server Database Engine used to host the report server database.
[...]
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

834 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