Jobs Failed to run

• solomon.jernas

  Hall of Fame

  Points: 3680

  More actions

  April 7, 2011 at 10:40 am

  #97818

  Hi,

  I am getting in when i ran the job in sql server 2000.

  This is error

  Executed as user: VISTEON\SQLSRVC1. DTSRun: Loading... Error: -2147217843 (80040E4D); Provider Error: 18456 (4818) Error string: Login failed for user 'sa'. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0. Process Exit Code 1. The step failed.

  Please anyone help me..

• RP_DBA

  SSCertifiable

  Points: 5116

  More actions

  April 7, 2011 at 4:10 pm

  #1308879

  Check this out: http://support.microsoft.com/kb/269074

  _____________________________________________________________________
  - Nate

  @nate_hughes