• Article

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Details

Product Name

SQL Server 

Product Version

10.0

Product Build Number

Event ID

-1071611876

Event Source

dtsmsg.rll

Component

Integration Services 

Symbolic Name

DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Message Text

The AcquireConnection method call to the connection manager "__" failed with error code __. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

Explanation

The package cannot run because a specified connection failed.

The hexadecimal value for this error number is 0xC020801C.

Possible Causes

This message might appear because of one of the following problems:

  • The connection string specifies a provider that is not supported.

  • You do not have the correct permissions to use SQL Server Agent to run the package.

  • You do not have access to the specified data source.

  • The specified data source is not available for a variety of reasons, depending on the type and location of the data source. For example, a data source might not be available for the following reasons:

    • The network is not operating.

    • The server is not available.

    • Another application is using the data source file.

  • The connection manager is configured to use SQL Server Authentication, but the package configuration file does not contain the needed password.

User Action

Depending on why the specified connection failed, you might have to take one of the following steps:

  • Modify the connection string to specify a provider that is supported. For more information about supported providers, see the documentation that comes with SQL Server Upgrade Advisor.

  • Verify that you have the correct permissions to use SQL Server Agent to run the package. For information about how to troubleshoot packages that are run from SQL Server Agent jobs, see the Microsoft Knowledge Base article, An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step.

  • Verify that you have access to the specified data source.

  • Verify that another application is not using the specified data source.

  • Modify the configuration file of the package to include the password that SQL Server Authentication requires. To modify the configuration file to include this password, run the Package Configuration Wizard, which will export the PackagePassword property of the package to the configuration file.