Error on SSRS Manage processing Options

We were working on SSRS 2012 integrated with SharePoint 2013.

Whenever we use to click any SSRS reports => Manage Processing Options we use to get error:

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’.

Open SharePoint 2013 Central Administration and navigate to your Reporting Services Service Application.

Click ‘Provision Subscriptions and Alerts’

Click ‘Download Script’

Run these scripts on SQL Server, where your Reporting services databases reside.

This SQL script fixed our problem, and we could see the processing options page.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s