Sample Header Ad - 728x90

SSIS packages fail with Pending Execution Status

1 vote
1 answer
12697 views
My packages have been running on our production environment for a couple of weeks until they started failing with very little information apart from packages having a pending execution status. All packages fail regardless of the user executing them e.g. myself or the SQL Agent service account. There is a cryptic error message in the windows log about activation permissions for the SQL Integration Services. Setting permissions for the accounts calling the package makes no difference, I managed to get them working by repairing the SQL Server installation I couldn't see what repairs it had made. Now following a reboot of the server all packages refuse to run. I have managed to get them to work by repairing the SQL Server installation again. This is obviously not a scalable solution. I suspect that some group policy setting is overriding a local security setting and this is why it happens after some time or after a reboot. Has anybody come across this issue before or have any ideas where to look.
Asked by Steve (174 rep)
Mar 26, 2018, 01:14 PM
Last activity: Mar 16, 2024, 10:58 AM