Question
What if the SQL Server Agent is running under a different account than the proxy account? How does that affect authentication?
Asked by: USER3283
126 Viewed
126 Answers
Answer (126)
The SQL Server Agent service account and the proxy account are distinct. The Agent service account needs permissions to *start* the job, but the job itself executes under the context of the proxy account. Therefore, the proxy account's credentials must be valid for accessing the resources the job needs, regardless of the Agent service account's permissions.