MyDomain\UserA has a login with a server role of
public and is a user of the
msdb database with membership in the
The user owns a job,
Daily Job. When logged in as the user, if I try to view the job properties, I get this error:
Cannot execute as the database principal because the principal "guest" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Microsoft Server, Error: 15517)
If I right click on
Jobs and Select
New Job... I get the exact same error.
I have even given the user membership in
SQLAgentOperatorRole but get the same error.
In all my searching online, the only similar issue I've found is this question on MSDN, which is unanswered.
Any ideas? I'm at a loss here.