December 13, 2017 at 8:49 am
Hi All,
I have an SSIS Packages which call .exe from operating system. It is running when i execute package from SSIS.
But, When I prepare a SQL Server Agent which calls the SSIS package, it is hanging. I see my executable in the task manager with no owner. But it never ends.
What would be the problem. Do you have security config suggestions? Or another suggestions may be?
December 13, 2017 at 9:12 am
Thinky Night - Wednesday, December 13, 2017 8:49 AMHi All,I have an SSIS Packages which call .exe from operating system. It is running when i execute package from SSIS.
But, When I prepare a SQL Server Agent which calls the SSIS package, it is hanging. I see my executable in the task manager with no owner. But it never ends.
What would be the problem. Do you have security config suggestions? Or another suggestions may be?
It's likely to be a permissions problem. Does the SQL Agent user have the necessary rights?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
December 13, 2017 at 9:30 am
Thanks Phil Parkin,
I find the problem, My executable is generating an output file. Where you run executable, it generates output file there. So i need SQL Server Agent Working Directory to delegate the service account?
Help, please.
December 13, 2017 at 12:09 pm
Thinky Night - Wednesday, December 13, 2017 9:30 AMThanks Phil Parkin,I find the problem, My executable is generating an output file. Where you run executable, it generates output file there. So i need SQL Server Agent Working Directory to delegate the service account?
Help, please.
Make the SQL Agent service account a Windows domain service account and grant the necessary permissions to that account.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply