locked
Error code: 0x80004005 SSIS DTS_E_OLEDBERROR RRS feed

  • Question

  • Error 6 Validation error. SA_DART_PreCalculated Connection manager "DART": SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft SQL Server Native Client 10.0"  Hresult: 0x80004005  Description: "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.".   SA_DART_PreCalculated.dtsx 0 0 
    Wednesday, March 21, 2012 7:29 PM

Answers

All replies

  • Hello George,

    Seems you are operating in a joint-domain environment and since the user in one is not mapped or exist in the other throws this error.


    Arthur My Blog

    Wednesday, March 21, 2012 7:33 PM
  • Hello,

    The below thread might help you.

    http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/11/10/ssis-error-code-dts-e-oledberror-an-ole-db-error-has-occurred-reasons-and-troubleshooting.aspx

    http://blogs.msdn.com/b/jorgepc/archive/2008/02/12/ssis-error-dts-e-cannotacquireconnectionfromconnectionmanager-when-connecting-to-oracle-data-source.aspx

    Thursday, March 22, 2012 5:25 AM
  • Hi George Zhou,

    According to the error message, it seems that the Windows Account you are using could not be authenticated by Active Directory Server, please verify the account have sufficient permission to access the domain. For more details about the issue, please refer to Jason's reply in the following thread: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/6dfc6463-658b-4a96-9cf3-b1e5c9a0fc52

    Additionally the issue is most related to SQL Server Security, you can post the question to SQL Server Security forum: http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/threads 

    Thanks,
    Eileen

      
    • Proposed as answer by Eshani Rao Monday, March 26, 2012 3:34 AM
    • Marked as answer by Eileen Zhao Friday, March 30, 2012 1:26 AM
    Monday, March 26, 2012 3:32 AM
  • Hello,

    Check the link below. It will help you.

    http://blogs.msdn.com/b/dataaccesstechnologies/archive/2009/11/10/ssis-error-code-dts-e-oledberror-an-ole-db-error-has-occurred-reasons-and-troubleshooting.aspx

    Monday, March 26, 2012 5:22 AM