Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2014
    Posts
    4

    Unanswered: SQL Server Agent

    Hello,

    I have set up a SSIS Package using Business Intelligence Development Studio. The package has been running fine until a day ago. I changed nothing in the SQL Server Schedule. I am getting this error message:

    Message
    Executed as user: DWPRODDB2\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:19:55 AM Error: 2014-12-12 11:19:56.44 Code: 0xC0202009 Source: Populate Recruiter ODS Connection manager "RECRUITER_PRODUCTION" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4D. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E4D Description: "Login failed for user 'AD\DWPRODDB2$'.". End Error Error: 2014-12-12 11:19:56.44 Code: 0xC020801C Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY OLE DB Source - SPT_REC_ACAD_HISTORY [1] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER . The AcquireConnection method call to the connection manager "RECRUITER_PRODUCTION" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2014-12-12 11:19:56.44 Code: 0xC0047017 Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY SSIS.Pipeline Description: component "OLE DB Source - SPT_REC_ACAD_HISTORY" (1) failed validation and returned error code 0xC020801C. End Error Error: 2014-12-12 11:19:56.44 Code: 0xC004700C Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2014-12-12 11:19:56.45 Code: 0xC0024107 Source: Data Flow Task - Populate SPT_REC_ACAD_HISTORY Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:19:55 AM Finished: 11:19:56 AM Elapsed: 0.733 seconds. The package execution failed. The step failed.
    Can anyone help? or know what this mean?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Login failed for user 'AD\DWPRODDB2$' for connection RECRUITER_PRODUCTION


    Check the login details are still valid, that passwords haven't expired or changed, etc.
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    Is the target server mirrored, or in an Availability Group?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •