SSIS version 2016 SP2 runs in Server A
database version: 2016 runs in Server B
I deployed packages and configured connection manager Service user call "SRV_CRM_report"(AD user) login in under Server A SSIS Integration Service catalogs) . "SRV_CRM_report" AD user has permission on Server B database and checked
Now package has scheduled to run though the agent on Server A( service user call "Server-A_AG").
When I run the SSIS job from the agent(Server A), then its failed . Then I granted permission to Server-A_AG service user database on Server B.
That shows package connection manager user "SRV_CRM_report" and didnt use to connect to Server B.
Now the SSIS job is running from the agent (SERVER A) . I checked the process and I can see job is running using Server-A_AG service user NOT from "SRV_CRM_report"
Is that mean do I have to use proxy user to define as "SRV_CRM_report" ?
Wired the SSIS pkg the way it runs
Can you please advice how do I get it run using SRV_CRM_report"