AccessDeniedException when deploying Rdl to SP2010 Claims based site

This Post by Adam Saxton saved me hours of time today.

http://blogs.msdn.com/b/psssql/archive/2012/07/12/sharepoint-adventures-access-denied-errors-when-using-rs-2012-with-a-claims-sharepoint-site.aspx

I setup SP2010 with SQL 2012, all appeared to be working until I create a rdl and tried to deploy it into SharePoint from BIDS in VS2010.  Got the error: The permissions granted to user are insufficient for performing this operation. reporting services + AccessDeniedException.

Resolution: This is a permissions issue on the SharePoint site, I opened the url http://<sitecollection>/_layouts/people.aspx?membershipGroupId=0

I had 2 identical accounts: demo\administrator & DEMO\Administrator.  I ran the select statement explained by Adam to check the user table on the content db where the site collection sites:
SELECT tp_login, tp_title, tp_delete from UserInfo

I deleted the NT account (not the claim account) using the SP UI (http://<sitecollection>/_layouts/people.aspx?membershipGroupId=0).  Re-ran the T-SQL query and the offending NT account (DEMO\Administrator) has been virtually deleted by SP.

I can now publish the report.

More Info on setting up SSRS for SharePoint:

• http://www.madronasg.com/blog/how-configure-sql-server-reporting-services-2012-use-sharepoint-2010
• http://thebaretta.blogspot.co.uk/2013/04/sharepoint-2010-sql-server-2012.html
• http://sperryh.wordpress.com/2012/09/06/lessons-learned-from-ssrs-2012-install-in-multi-farm-environment/