ERROR: User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

This happens when you are on the server and want to administer report content from the server.  In short, the problem is that the local user does not have permissions. It appears to be a bug in the how permissions get set up within SSRS.

RESOLUTION

Run IE, Firefox or whatever as administrator

Navigate to http://localhost/Reports - (Do not use http://<server name>/Reports)

From the Root Folder, Click on  "Folder Settings" as below



Click on New "Role Assignment" and add "Content Manager" to the person you want to administer your content

Adding critical logging to your procedures

Here is a little tip that will help produce detailed logging and debugging reference points:

Output the name of the stored procedure when it runs.  Simple.

Procedure names, much like anything else, can change over time.  So how do we keep up changes to those messy output strings?  You don't, Simple again.

Include this little jewel with your print output or logging output and see how easy it is to find your way back to the stored proc:
SELECT OBJECT_SCHEMA_NAME(@@PROCID) as [schema], OBJECT_NAME(@@PROCID) as [procedure]
Maybe really show off what a fancy coder you are by including it in your error handling:
BEGIN CATCH
     SELECT
     OBJECT_SCHEMA_NAME(@@PROCID) as [schema],
     OBJECT_NAME(@@PROCID) as [procedure],    
     ERROR_NUMBER() AS ErrorNumber,     
     ERROR_SEVERITY() AS ErrorSeverity,     
     ERROR_STATE() AS ErrorState,     
     ERROR_PROCEDURE() AS ErrorProcedure,     
     ERROR_LINE() AS ErrorLine,     
     ERROR_MESSAGE() AS ErrorMessage;
END CATCH;   

Nice article about running totals against aggregated row items in SSRS

http://mangalpardeshi.blogspot.com/2009/02/running-totals-in-sql.html