Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OLEDB Error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER Expand / Collapse
Author
Message
Posted Wednesday, July 24, 2013 4:49 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 7:27 AM
Points: 331, Visits: 750


I have a OleDB connection mgr being used in a SQL Server Destination task in a pkg in which I want to use SQL Authentication with the username and pasword of a SQL user which has already been granted access to the database. When I open the connection mgr and type in the password and click save password then click test connection it connects but when I run it I get the following error. and after I open it again the checkbox for saving the password is still checked but the textbox where I typed the password is blank.


[SQL Dest - Tbl_BOM [23]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "C9100970E1DB44B.HDC.HDC_Worker" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Post #1476974
Posted Thursday, July 25, 2013 10:34 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 2:02 PM
Points: 150, Visits: 628
Later version - Same Error. The answer for me was to create a configuration file for the SSIS package. The problem was that Microsoft is being security conscious. Also, I am using windows authentication. The full answer is to create the configuration file and then exit from the editor and edit the configuration file separately in notepad or some other text editor. The passwords are not saved and will be removed from the package and the configuration file when you edit it even though you tell it to save the passwords.
Post #1477623
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse