PGP encryption/decryption fails as a sql server agent job

• ramkidec11

  SSC Veteran

  Points: 234

  More actions

  April 24, 2013 at 8:59 am

  #276824

  Hi All,

  I am trying to encrypt the text file before putting it on the SFTP. The package runs fine with BIDS and when i run after importing to the integrations services it executes perfectly fine. It executes even when ran from the cmd line. But the problem arises when it is run from SQL server agent.

  i am running as a admin and that has all the rights to the folders. what else am i missing?

  Thanks

  RK

• arnipetursson

  SSCertifiable

  Points: 6557

  More actions

  April 24, 2013 at 9:29 am

  #1609581

  Unless you are using credential/proxy to run the SQL agent job step, it will be run

  by the service account that runs the SQL Agent service.

  So either make sure the service account has the appropriate permissions or create a

  credential/proxy with the correct permissions and assign it to run the job step.