Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

Question

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.".

Answer 1

Hi N.J.,

I suggest comparing some properties with another server where the package currently works fine.

Try to compare the following:

Firewall rules

SSIS catalog properties

SQL Server Agent job properties

Here’s a helpful link: https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/sql-server-faces-connectivity-issue-ssispack-fail