Home Forums Reporting Services Reporting Services Subscriptions and error message "EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'." RE: Subscriptions and error message "EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'."

  • April 27, 2015 at 6:11 am

    #1793622

    In my case the report server account already had RSExecRole in all relevant databases. Grant exec on procdure to role in master database helped:

    use [master]

    GO

    GRANT EXECUTE ON [sys].[xp_sqlagent_notify] TO [RSExecRole]

    GO