Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

Noopura Jaiswal 0 Reputation points
2024-06-19T02:01:51.49+00:00

This is the error message I receive when I run a SSIS package. Only one particular server is causing this issue other servers are connecting and package is getting executed.

Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "OleDbConnectionManager" failed with error code 0x80004005. Wait 5 seconds to retry.

[Connection manager] Error: 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: "Client unable to establish connection due to prelogin failure".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "TCP Provider: An existing connection was forcibly closed by the remote host.

".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Client unable to establish connection".

An OLE DB record is available. Source: "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.".

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
510 questions
0 comments No comments
{count} votes