SSRS Error: Execute permission denied on object ‘sp_add_category’

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 Server 2005–> Configuration Tools–>Reporting Services Configuration
2. Select the instance (local or remote)
3. Click on Database Setup
4. On the Credentials Type, select a different type than a current one.  I selected Windows Credentials and enter the Account Name and Password for the account with appropriate priveleges.
5. Press Apply  – This will grant database privileges.
6. Try creating a subscription.
This worked for me.

About Sylvia

Hobbies include bike riding, Puerto Rican history, genealogy and preserving her family's history for many generations.
This entry was posted in SQL Server 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s