Anonmyous Access affecting Reporting Service webpage

[M8tt]

I have a user who has developed a simple reporting website using Reporting Services.

This uses anonymous access in IIS, but I need to disable this so that I can pass user credentials through to the SQL Server which runs on the same machine.

However when I disable anonymous access (IIS Manager > ReportServer > Properties > Directory Security > Auth and access control Edit > Enable anonymous access unchecked) the tabs on the webpage, links to the sub-folders and buttons to create new folders, data sources and reports on the homepage all disappear. Although the page itself still loads up.

As soon as I re-enable anonymous access the links return and it works again.

I was thinking this was a permissions issue so added the Everyone group to the Permissions (Read & Execute, List Folder Contents and Read) for the Reports and ReportServer sites in IIS, but still have the same problem.

I'm not really familiar with Reporting Services so am unclear if the problem is there or with IIS (or both).

Any suggestions on how to resolve this would be much appreciated.

Thanks, Matt

 

[mrdenny]

You'll need to give the users rights within Reporting Services. On the root folder, click the properties tab and grant users the needed rights. Then try requiring authentication again.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

 

[M8tt]

Many thanks Denny that has worked.

I must of checked the permissions on the folders beneath root half a dozen times without realising I needed to do the same thing on root itself.

Thanks again, Matt

 

[mrdenny]

No problem. Got bit by that one myself a few times.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog