Wednesday, February 15, 2012

SQL Error The permissions granted to user "Domain\User" are insufficient for performing this operation. (rsAccessDenied)


Problem :

I have a SQL2008 Report hosted on a server and I want to allow all authenticated user to be able to access this report and I am getting following error , even though anonymous setting is enable at IIS



Root cause
SQL 2008 Reporting services Manager does not allow  anonymous because of role base security model

Troubleshooting

Use global security token “NT AUTHORITY\Authenticated Users” that represent all Active directory authenticated user


References
http://odetocode.com/Articles/215.aspx
http://technet.microsoft.com/en-us/library/bb457115.aspx
http://forums.techarena.in/server-scripting/335097.htm


Posted by at
Labels: ,

3 comments:

  1. AnonymousJune 20, 2021 at 12:17 AM

    They're produced by the very best degree developers who will be distinguished for your polo dress creating. You'll find polo Ron Lauren inside exclusive array which include particular classes for men, women. store name ideas

    ReplyDelete
  2. Darren DemersJune 26, 2021 at 3:04 AM

    Kuchi Jewels is a project of Gem & Gems which is a leading exporter since 2005 to onwards in all over the world. Our company has experienced, educated and motivated staff. Our main goal is to meet the international standard B2C and B2B export target with competitive prices and high quality products. chamilia canada , chamilia australia ,

    ReplyDelete
  3. shzOctober 8, 2021 at 9:03 AM

    This post is good enough to make somebody understand this amazing thing, and I’m sure everyone will appreciate this interesting things. more info

    ReplyDelete

Subscribe to: Post Comments (Atom)