sql server reporting services: security problem about ReportServer -- sql server reporting services

security problem about ReportServer

David Zhu
5/23/2006 8:35:01 AM

sql server reporting services:

Hi,

I want to allow the anonymous user to access the
http://server_name/ReportServer Site, but only allow administrators access
the http://server_name/Reports Site(Report Manager).

So I did the following settings in IIS:

1. For Report Manager, check on the integrated windows authentication check
on,
check out the anonymous accessing.
2. For ReportServer virtual directory, check on the anonymous acessing.

Then, the anonymous user could acess the ReportServer Site successfully, but
when the administrators enter report manager, some items were hidden by the
reporing service(such like property tab and security settings were hidden).

So How to fix this problem?

Thanks.

Re: security problem about ReportServer

Kaisa M. Lindahl Lervik
5/26/2006 2:05:50 PM

You need to get the Administrators Administrator RIghts in Report Manager.
Do you have an AD group for the users that are supposed to be admin? If not,
create one, and add all the users to it.

Log in as the RS Administrator, and add the Admin AD-group to the top level
in Report Manager.
On the root page, click Properties, click Security, then click New Role
Assignment.

Type in the name of the AD group, (domain\groupname) and give it the Content
Manager role. Click OK. Ask them to reload their Report Manager page and see
if they can see the button now.

Kaisa M. Lindahl Lervik

[quoted text, click to view]