Permissions necessary to access SQL 2008 Reporting Services Configuration Manager

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.
snowmizerAsked:
Who is Participating?
 
lcohanConnect With a Mentor Database AnalystCommented:
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
 
lcohanDatabase AnalystCommented:
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
 
snowmizerAuthor Commented:
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
 
lcohanDatabase AnalystCommented:
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
 
snowmizerAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.