What if the SQL Server Agent is running under a different account than the proxy account? How does that affect authentication?

Responsive Ad Header

Question

Grade: Education Subject: Support
What if the SQL Server Agent is running under a different account than the proxy account? How does that affect authentication?
Asked by:
126 Viewed 126 Answers

Answer (126)

Best Answer
(359)
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.