none
Hi Microsoft,Would you please help to check why "Microsoft SQL Server Native Client 11.0" "Login timeout expired"? RRS feed

  • Question

  • Executed as user: AIA\DITD938. Microsoft (R) SQL Server Execute Package Utility Version 11.0.7001.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:10:00 PM Error: 2018-12-16 22:10:17.65 Code: 0xC0202009 Source: dts_FollowUp_AUND Connection manager "CGKDCPWSQL04" Description: 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 11.0" Hresult: 0x80004005 Description: "Login timeout expired". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Unable to complete login process due to delay in login response". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: Timeout error [258]. ". End Error Error: 2018-12-16 22:10:17.65 Code: 0xC020801C Source: Data Flow Task OLE DB Destination [27] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "CGKDCPWSQL04" 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: 2018-12-16 22:10:17.65 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: OLE DB Destination failed validation and returned error code 0xC020801C. End Error Error: 2018-12-16 22:10:17.65 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2018-12-16 22:10:17.65 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:10:00 PM Finished: 10:10:17 PM Elapsed: 16.895 seconds. The package execution failed. The step failed.


    Wednesday, December 19, 2018 9:00 AM

Answers

All replies