Error while opening SharePoint 2013 Reporting Service configuration wizard

Error in Open Menu – SQL Server 2012 Reporting Services Integration with SharePoint 2013

By Tirtha Ghosh  •  November 11, 2014  •  4150 Views

Netwoven Blog

You are using SharePoint 2013 with SSRS 2012 in the SharePoint Integrated mode. In the SharePoint Reporting Libraries, you will see below error when you try access the ECB menus related Reporting Services caching and subscriptions options.

  • Manage Processing Options
  • Manage Cache Refresh Plans
Error in Open Menu - SQL Server 2012 Reporting Services Integration with SharePoint 2013

Sorry, something went wrong

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.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

Cause

Due to lack of complete configuration steps in the SSRS Service Application, you will experience these errors.

Resolution:

Method – 1 (Recommended)

  • Select ‘SQL Reporting Services Service Application’ from Manage service applications page, under Central Administration.
  • Click ‘Provision Subscriptions and Alerts’
  • Click ‘Download Script’
  • Run these scripts on SQL Server

Method – 2 (Manual)

First you need to verify ‘SQL Service’, ‘SQL Agent Service’ services account are added to RSExecRole role on Reporting Service, Reporting Services Temp, master, msdb databases.

Secondly and foremost, SQL Reporting Services Service Application Pool account is also added in RSExecRole. For instance, when user clicks ‘Manage Processing Options’ from report properties, behind the scene database connection is made using ‘Integrated Security = true’.

Leave a comment

Your email address will not be published. Required fields are marked *

Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Microsoft Partner
Unravel The Complex
Stay Connected

Subscribe and receive the latest insights

Netwoven Inc. - Microsoft Solutions Partner

Get involved by tagging Netwoven experiences using our official hashtag #UnravelTheComplex