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.
Resolution
The issue was first fixed in the following cumulative update of SQL Server.
Cumulative Update 9 for SQL Server 2012 SP1 /en-us/help/2931078
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.
