Cant Acquire Connection from SQL Agent

• RC-874851

  SSC Enthusiast

  Points: 142

  More actions

  October 31, 2008 at 12:00 pm

  #154870

  I have a package that

  1st deletes data in database using SQL , this works always

  2nd reads Excel file from network drive, this only works when I execute it. If its run as a job under Agent using a proxy it fails on the connection everytime.

  Our network folks setup the proxy account and have verifed it has access to the directory and file.

  What could I not being correctly

  Any help appreciated.

  Richard

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  November 1, 2008 at 7:34 am

  #892712

  Can you post as much information from the error as possible?

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  

• rcarrier

  SSC-Addicted

  Points: 495

  More actions

  November 1, 2008 at 8:32 am

  #892725

  Thanks,

  It turns out the network folks thought they had permissions set but really didn't

  Its working now