When executing jobs created by Maintenance Plan, received error:
...
SELECT permission denied on object 'sysdbmaintplans', database 'msdb', owner 'dbo'
...
Msg 50000, Level 16, State 1, Line 0
LiteSpeed maintenance plan failed.
sysadmin privilege of the SQL Server service account is revoked.
Use an domain account to start up the SQL Server service which has to be granted as local administrator on the Windows OS and granted sysdmin privilege on the SQL Server.
,
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center