Share via


SharePoint SSRS Troubleshooting: System.Data.SqlClient.SqlException - The EXECUTE permission was denied on the object ‘xp_sqlagent_notify’, database ‘mssqlsystemresource’, schema ‘sys’.

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