SQL Report Manager Security Settings

dwhitfield_CPWN
dwhitfield_CPWN used Ask the Experts™
on
Hi,

I am in the progress of setting up permissions for report manager and have come across a couple of issues.

The "Site Settings" has me as a system administrator.
The root folder setting (Home) has me with all the the roles selected.

When my colleague browses the report manager, he can access the folder and site settings and has the ability to create new users.

He also has viability of all reports deployed (even though he is not added as a user to the folder.)

Should my colleague be able see these settings as he is not added as user to any security level???

I have found this link where people have said the security settings are ignored for local admins.

http://www.sqlservercentral.com/Forums/Topic590402-162-1.aspx

Does anyone know of a way I can get round this issue?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Initially, only users who are members of the local administrators group can access a report server. Reporting Services is installed with two default role assignments that grant item-level and system-level access to members of the local administrators group. These built-in role assignments local Administrators to grant report server access to other users and manage report server items. The built-in role assignments cannot be deleted. A local administrator always has permission to fully manage a report server instance.

Because full permissions on a report server include item-level and system-level permissions, a local administrator is assigned to the following roles:

•System Administrator Role

•Content Manager Role

From the following website

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

As long as your colleague is a local administrator on the server hosting SQL Server 2008 Reporting Services then he will be a member of the System Administrator Role and Content Manager Roles on Reporting Services.

Author

Commented:
Thanks. I understand the functionality now. Its a shame the RS security permissions do not overwrite local admin.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial