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 |
|
stevelund
Starting Member
5 Posts |
 Posted - 2008-02-12 : 07:42:23
|
| Hi,I'm trying to setup a subscription on a SSRS report and get the following error message:An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'. I've followed the advice given in this post but still get the same result.The SQLAgent service is running under a domain account and the Reporting Services service running under a local account. Both these accounts are assigned to the RSExec Role in the master, msdb, ReportServer and ReportServerTempDB databases. This role has execute permissions set as per the above link.I'm now at a loss as to what else the problem could be?All ideas welcomed!Steve. |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2008-02-20 : 16:34:54
|
| you have to create a role called RsExecRole in ReportServer, ReportServerTempDB, master and msdb. You probably have it in ReportServer and ReportServerTempDB if you backed up your database and restored it on a new SQL server. |
 |
|
|
|
|
|
Report Subscriptions problem