What is the difference between sql server agent account VS ssis_proxy

Question

when i create a new package in ssis if i forgot to assign the run as dialog to ssis_proxy , it thow an error message that ssi does not see the package , so i want to know what is the difference between sql server agent account vs ssis_proxy

Answer 1

Hi @Ahmed Serry abdul hameed,

In a word, the SQL Server Agent Account is used for general job automation and task execution in SQL Server.

SQL Server proxy account defines a security context in which a job step can run. Each proxy corresponds to a security credential. To set permissions for a particular job step, create a proxy that has the required permissions for a SQL Server Agent subsystem, and then assign that proxy to the job step.

See SQL Server Agent proxy.

Set the Service Startup Account for SQL Server Agent

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

what i mean is --> in this part if i chose sql service agent account ssis does not see the other job that sequence of steps so i need to choose ssis_proxy , so i need to know why , what is the difference ?