An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database

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. Upon saving the subscription you see the error on the screenshot above.

In log file C:\Program Files\Microsoft SQL Server\MSRS13.SSRS\Reporting Services\LogFiles\ReportServerService__date_time.log

you will see the following:

Thus “The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.

In order to fix this log in to SQL database server where Reporting Server’s database resides and execute the following SQL commands:

Refer this article for more details.

Good luck!


Want me to do this for you? Drop me a line: itgalaxyzzz {at} gmail [dot] com