SELECT permission denied on object 'sysdbmaintplans', database 'msdb', owner 'dbo' (4354456)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

SELECT permission denied on object 'sysdbmaintplans', database 'msdb', owner 'dbo'
Description

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.
Cause

sysadmin privilege of the SQL Server service account is revoked.
Resolution

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.
,

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title