Email subscription permission denied on SSRS 2000
-
When I try to set up an email subscription for SSRS 2000, I get: EXECUTE permission denied on object 'sp_add_category', database 'msdb', owner 'dbo'. The dbo user for the msdb has admin priviledges. I'm stumped on what to do or look for. Found this in the catalog.sql file: GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRole I ran this script for the msdb database via Query Analyzer, tried the subscription again, and got: An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'sp_add_category', database 'msdb', owner 'dbo'. We're connecting to the db server from a shared datasource w/ a user, let's say "reportuser", that has only "Read Access" to pull the data. Any suggestions? Thanks!