On SQL Server 2012 (SP1) Reporting Services (native), when creating a cache refresh plan in Report Manager, I receive the error:
Only members of sysadmin role are allowed to update or delete jobs owned by a different login.
This is unexpected because:
Isn't it creating a job, not updating or deleting an existing one?
The owner_sid of all the existing jobs in the "Reporting Services" category is that of
NT Service\ReportServer. (Not sure how these were ever successfully created, somebody else must have created them.)
NT Service\ReportServeris in the
The service is indeed running as
I can "fix" this by giving
NT Service\ReportServer the
sysadmin (thus verifying the login being used is really
NT Service\ReportServer). However, that level of access shouldn't be necessary given the facts above.