Category Archives: SQL Server 2005

SSRS Error: Execute permission denied on object ‘sp_add_category’

Posted on June 13, 2008 by Sylvia

  While attempting to schedule a SSRS 2005 report by creating a SUBSCRIPTION, I encountered the error Execute permission denied on object ‘sp_add_category’.   Followed the following steps recommended on TechNet: 1. Open Start –> All Programs –> Microsoft SQL … Continue reading →

Posted in SQL Server 2005 | Leave a comment