FIX: Error when you create new report subscriptions after you apply CU7 or CU8 for SQL Server 2012 SP1
Content provided by Microsoft
Applies to: Microsoft SQL Server 2012 Service Pack 1Microsoft SQL Server 2012 EnterpriseMicrosoft SQL Server 2012 DeveloperMicrosoft SQL Server 2012 StandardMore
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.
The issue was first fixed in the following cumulative update of SQL Server.
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: