Click here to Skip to main content
15,885,365 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi 

I have a SSIS package that executes a gpg program via command line.  The SSIS package runs from a SQL Agent job using a proxy account (a domain account).  This account has an administrator on the server so should have full access to run the gpg program.

These are expected: 
- The SSIS package runs when executed manually.
- The SQL Job runs when executed manually.

Here is where it is unusual:
-When running automatically when scheduled, the package executes successfully only if the proxy account (a domain user) is logged into the server.
-When the proxy account is logged off, the scheduled job fails when trying to execute the GPG command line program.

Any ideas?


Thanks in advance for any advice!


What I have tried:

I have done so much research and it appears the proxy is setup correctly in SQL Server.
Posted
Updated 21-May-18 12:23pm
Comments
Richard Deeming 21-May-18 17:06pm    
Sounds like the program you're trying to run requires a user profile. AFAIK, jobs started by the SQL Agent service don't load the user profile.
mgoad99 21-May-18 18:22pm    
Thank you so much for that tip! I believe I have fixed the issue by copying the user profile data for the gpg application in question to the default user profile.

1 solution

Thanks to RichardDeeming, I found the solution to my problem.

This article also helped, in case anyone else finds this question.

command line - Windows Account Can't See gpg Key - Super User[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900