Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Error
This error occurred when trying to access the Manage Processing Options in SharePoint SSRS.
https://lh3.googleusercontent.com/-YoESjcPsXOE/V0wKsnqQ7RI/AAAAAAAAMu4/Cnuy61XxEpo/image_thumb%25255B2%25255D.png?imgmax=800
“An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. —> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.”
Cause is configuration issue and provisioning issues of Reporting Server user on related databases (Master, SSRS)
Resolution
You can resolve the issue by rerunning the script on your database server.
For that, you can download the report from the Central Admin via
Application Management > Manage service applications
https://lh3.googleusercontent.com/-4RhNGaeMKiI/V0wKttb37JI/AAAAAAAAMvA/_aX1gBxCcEI/image_thumb%25255B4%25255D.png?imgmax=800
Then go to Provision Subscription and Alerts (Reporting Services service application)
https://lh3.googleusercontent.com/-nhlykDXBkGo/V0wKuiUicFI/AAAAAAAAMvI/Mj1gDBjygt0/image_thumb%25255B7%25255D.png?imgmax=800
Click Download Script and execute in the database server.
https://lh3.googleusercontent.com/-tubX-3WqnAY/V0wKvlAnvHI/AAAAAAAAMvQ/wrvRA61dFeo/image_thumb%25255B10%25255D.png?imgmax=800