Hi There,
I was working with SharePoint SSRS and the reports were working fine. However when i click "View Report History" it gave me the below error.
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'.
I found an answer here but i was looking for some systematic way than running SQL Server queries. So i found a solution here which worked for me.
So the solution is:
1. Open SharePoint Central Administration > Application Management > Manage Service Applications
2. Click on your SQL Server Reporting Services Service Application
3. Click on “Provision Subscriptions and Alerts” link
4. Type a username and password for SQL Server which grants privilege to your SSRS service application pool.
2. Click on your SQL Server Reporting Services Service Application
3. Click on “Provision Subscriptions and Alerts” link
4. Type a username and password for SQL Server which grants privilege to your SSRS service application pool.
5. Save and try again
Boom....! It worked.
Happy SharePointing :)
Subscribe by Email
SharePoint: The EXECUTE permission was denied on the object 'xp_sqlagent_notify
4/
5
Oleh
Fury
