LoadFromSQLServer failed [SQLSTATE 01000]

• Daniel Melgarejo

  SSC Rookie

  Points: 37

  More actions

  February 21, 2005 at 1:22 pm

  #162660

  Hello

  When I run a SP that executes a DTS Package  I get the the following error:

  ***  LoadFromSQLServer failed [SQLSTATE 01000]

  OLE Automation Error Information [SQLSTATE 01000]

  HRESULT: 0x80040e4d [SQLSTATE 01000]

  sp_OAGetErrorInfo failed. [SQLSTATE 01000]

  But if I execute the DTS Package manually it works fine!! What is wrong??

  Thanz,

  Daniel

   

• DSP-120308

  Hall of Fame

  Points: 3959

  More actions

  February 21, 2005 at 7:34 pm

  #543386

  Could be a permission issue (easiest to check at least)

• philcart

  SSC-Forever

  Points: 47795

  More actions

  February 21, 2005 at 8:30 pm

  #543392

  A quick "google" on the HRESULT returns

  "0x80040E4D -2147217843 Authentication failed"

  Pretty much points the finger at permissions

   

  --------------------
  Colt 45 - the original point and click interface