Due to pains and suffering with a clustered SQL Server installation, I need help with an SSIS issue. To take all the cluster mess out of the equation, we put SSIS on the app server. Packages are stored to msdb on the cluster - I don't think that should be a problem. However, I now want to execute the packages from a job on the SQL Server cluster, and no matter what I do with config I get "access denied" on the job. I can directly execute the package without issue.
Is this a "two-hops" problem? From what I'm reading, it sounds like I'd need to run the job from the app server. Which would mean an install of the db engine on the app server (a clear no-no). Am I missing something?