In reporting services got this error "The permissions granted to user sysname\ASPNET are insufficient for performing this operation. (rsAccessDenied)"

• vinayak.v

  SSCrazy

  Points: 2414

  More actions

  November 2, 2010 at 8:32 am

  #240707

  hi...

  i'm using sql server 2008 with advance services

  the below error is of reporting services..

  "The permissions granted to user 'sysname\ASPNET' are insufficient for performing this operation. (rsAccessDenied)"

  when i'm trying to host appliction.. the above error is occured..

  it works fine when i try to execute locally.. but when i try to execute through the IIS i.e host application

  the above error is displayed.

  please help me....

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  November 2, 2010 at 9:23 am

  #1245488

  Check if adding 'sysname\ASPNET' user to "Content Manager" role is an option.

  If that is not feasible, please check if the below discussions help.

  http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/34ecf8e8-9c30-4f16-a7b0-c67f6e01ce68

  http://stackoverflow.com/questions/132812/the-permissions-granted-to-user-are-insufficient-for-performing-this-operation

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga