SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


OLEDB Error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER


OLEDB Error DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER

Author
Message
dndaughtery
dndaughtery
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2567 Visits: 1090
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.
Dave Vroman
Dave Vroman
Old Hand
Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)Old Hand (335 reputation)

Group: General Forum Members
Points: 335 Visits: 727
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search