Home > dts_e_cannotacquireconnectionfromconnectionmanager

How to fix DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER?

Alton Alexander
By Alton AlexanderUpdated on June 4th, 2022

This error code happens when the Data Transformation Services (DTS) cannot acquire a connection from the connection manager. This can happen for a number of reasons, including if the connection manager is not configured correctly, if the connection manager is not able to connect to the data source, or if the connection manager is not able to create the necessary connections.

You are here because you have a question about:

  • ssis error code dts_e_cannotacquireconnectionfromconnectionmanager
  • dts_e_cannotacquireconnectionfromconnectionmanager

1. Check the Connection Manager to see if it is set up correctly

The following steps need to be completed in order to check the connection manager:

  1. Verify that the server and client are configured to use the same connection manager.
  2. Verify that the server and client are configured to use the same transport protocol.
  3. Verify that the server and client are configured to use the same port number.
  4. Verify that the server and client are configured to use the same username and password.
  5. Verify that the server and client are configured to use the same hostname.
  6. Verify that the server and client are configured to use the same interface type.
  7. Verify that the server and client are configured to use the same security context.
  8. Verify that the server and client are configured to use the same authentication scheme.

2. Check to see if the connection manager is online

The steps to Check to see if the connection manager is online in order to fix dts_e_cannotacquireconnectionfromconnectionmanager are as follows:

  1. Open the Windows Connection Manager.
  2. On the left-hand side, under "Overview," find the connection you want to diagnose.
  3. On the right-hand side, under "Status," find "Connection is Online."
  4. If the connection is not online, follow the steps in the Diagnosing Connection Problems section to troubleshoot the issue.

3. Check to see if the connection manager is reachable

  1. Check the status of the connection manager.
  2. Check the network connection.
  3. Check the system time.
  4. Check the Windows Event Viewer.
  5. Check the WMI.

4. Check to see if the connection manager is available

  1. Check the system health to see if the connection manager is available.
  2. If the connection manager is not available, try to connect to the connection manager using the "Connect-SQL Server" cmdlet.
  3. If the connection manager is available, try to connect to the connection manager using the " Connect-SqlServer " cmdlet.
  4. If the connection manager is not available, try to connect to the connection manager using the " Connect-SqlServer " cmdlet.
  5. If the connection manager is available, try to connect to the connection manager using the " Connect-SqlServer " cmdlet.

5. Restart the connection manager

  1. Restart the connection manager.
  2. Verify that the connection manager can acquire a connection from the network.
  3. If the connection manager cannot acquire a connection from the network, troubleshoot the network connection.

6. Check to see if the connection manager is configured correctly

  1. Check the DTS application log for errors.
  2. Check the DTS application configuration.
  3. Verify that the communication interface is enabled and configured correctly.
  4. Verify that the network path is available and the appropriate security settings are in place.
  5. Verify that the connection manager is properly registered with the DTS application.

If the answers above didn't work then you should also try:

  1. Check to see if the connection manager is functioning properly.
  2. If the problem persists, contact the administrator.