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'."

  • March 26, 2017 at 8:57 pm

    #1935005

    I had this issue due to having the Reporting Services databases in an Availability Group.   When we failed over (for the first time) there were a bunch of permissions not correctly set, specifically the RSExecRole was not there.   The reports worked, but not the subscriptions and we couldn't edit any of the report settings.

    Creating the RSExecRole,and assigning specific permissions via this link fixed the problem