Monday, May 30, 2016

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

 

This error occured to me when im trying to access the Manage Processing Oprions in SharePoint SSRS.

image

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 configurations isses and provisioning issues of Reporting Server User on Related Databases (Master , SSRS)

You can resolve the issue by re run the script on your database server.

For that you can downlod the report from the Central Admin by

Application Management  ->  Manage service applications

image

Then go to Reporting server service application

image

and clisk and download the script and execute in the database server.

image

Post a Comment