Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bubberz
Constraint Violating Yak Guru
289 Posts |
 Posted - 2007-03-05 : 16:09:45
|
| EXECUTE permission denied on object 'sp_add_category', database 'msdb', owner 'dbo'.This is for SSRS 2000.The dbo user for the msdb has admin priviledges. I'm stumped on what to do or look for.Any suggestions? Thanks! |
|
|
jhermiz
3564 Posts |
Posted - 2007-03-07 : 12:31:16
|
| Go to that specific user right click and view the properties. Click the permissions button and make sure the user has exec on that sproc. Cant believe you have not created a seperate role and user for your reports, you should be doing that!Programmers HowTo's -- [url]http://jhermiz.googlepages.com[/url] |
 |
|
|
bubberz
Constraint Violating Yak Guru
289 Posts |
Posted - 2007-03-08 : 12:13:33
|
| Yes, dbo does have execute permission for this sproc.Found this in the catalog.sql file:GRANT EXECUTE ON msdb.dbo.sp_add_category TO RSExecRoleI 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'. I found this in the .config file:<ConnectionType>Impersonate</ConnectionType> |
|
|
|
|
|
|
permission dendied for e-mail subscritpion w/ SSRS