Wednesday, 1 August 2007

Error "The permissions granted to user '\IUSR_' are insufficient in Reporting Server

If you get this error "The permissions granted to user '\IUSR_' are insufficient for performing this operation." when you work with Reporting Server, it is because the reporting server's virtual directories under IIS is running in 'Annonymous Mode'. To fix this open IIS, right click on the virtual directory that your report server uses, click on the tab 'Directory Settings' and click edit under 'Authentication and Access Control' and untick the 'Enable Anonymous Access'.

4 comments:

Anonymous said...

Thank you, I love you! That helped me with a whole bounce of problems! :)

P said...

I am having the same problem and i did exactly as u said...but i am having this problem

The permissions granted to user 'Machine-Name\ASPNET' are insufficient for performing this operation. (rsAccessDenied)

I am using XP pro sp2, SQL server express 2005, Visual Studio 2005

I am fighting with this for 10 days.
I am still not able to solve this
please help

Suprej Venkat said...

Hi P, check the account that you are using in the application pool that the IIS virtual directory for reporting server uses. Make sure that the account you have there has the necessary sql rights.

Jeremy Stein said...

Thank you!