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.
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:
To work around the issue, add SQL Server Reporting Services (SSRS) service account to sysadmin role in SQL Server.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.