locked
EXECUTE permission was denied on object 'xp_sqlagent_notify',database 'mssqlsystemresource' RRS feed

  • Question

  • hi ALL

    actaully i need to set an subscription on report but it give me error.

    even i tried with custom datasource as well.

     
    An error occurred within the report server database. This may be due to a connection
    failure, timeout or low disk condition within the database.
    (rsReportServerDatabaseError) Get Online Help The EXECUTE permission was denied on
    the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'. 

    Please help me to resolve this issue.

    Thanks

    Thursday, May 2, 2013 12:01 PM

Answers

  • Many thanks for reply.

    Error is resolved .

    Steps:
    1. In Mangement Studio connect to the SQL Server instance on which
    Reporting Services runs.
    2. Databases > system Databases
    3. master > Security > Roles > RSExecRole (then add whatever logins are
    required... check in the ReportServer or ReportServerTempDB databases if
    you're not sure)
    4. msdb > Security > Roles > RSExecRole (add the same logins you did to
    the master DB)

    • Marked as answer by Mike Yin Monday, May 6, 2013 4:29 PM
    Saturday, May 4, 2013 6:43 AM

All replies

  • Can you elaborate on the particulars of the architecture. Generally an execute permission like that has to do with user context.

    Jeff Block t:@sqlDictum (http://www.twitter.com/sqlDictum)

    Thursday, May 2, 2013 6:07 PM
  • Many thanks for reply.

    Error is resolved .

    Steps:
    1. In Mangement Studio connect to the SQL Server instance on which
    Reporting Services runs.
    2. Databases > system Databases
    3. master > Security > Roles > RSExecRole (then add whatever logins are
    required... check in the ReportServer or ReportServerTempDB databases if
    you're not sure)
    4. msdb > Security > Roles > RSExecRole (add the same logins you did to
    the master DB)

    • Marked as answer by Mike Yin Monday, May 6, 2013 4:29 PM
    Saturday, May 4, 2013 6:43 AM