Hi,
I have this issue: a developer told me that her SQL job (run a simple DOS command with her LAN id) failed. It worked before. The history shows: "A required privilege is not held by the client".
I checked the setting, proxy account was created and linked to her credential (LAN ID) and "Operating system (CmdExec) was selected with her proxy in "proxy account properties". The account is in "SQLAgentOperatorRole", "SQLAgentReaderRoler" and "SQLAgentUserRole". The account is the local admin group.
I modify the job step to run it with "SQL Server Agent Service Account". No problem.
Any idea or suggsetion? xp_cmdshell is not allowed to use.
Thank you
Yan