Symptoms

Assume that you have installed Cumulative Update 7 (CU7) or CU8 for Microsoft SQL Server 2012 Service Pack 1(SP1). When you try to create new report subscriptions in the portal for a report, you receive the following errors:

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. Only members of sysadmin role are allowed to update or delete jobs owned by a different login.

Cause

The issue occurs because there is a change both in CU7 and CU8 that causes SQL Server Agent’s permission check to incorrectly fail.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Workaround

To work around the issue, add SQL Server Reporting Services (SSRS) service account to sysadmin role in SQL Server.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×