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

SSIS - Failed to acquire connection Expand / Collapse
Posted Tuesday, February 5, 2013 10:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, September 10, 2015 1:06 AM
Points: 245, Visits: 102

I creating an SSIS package which has a script task in it.

In the script task, i have provided the details of connection string and the sql statements to get executed.

The problem is , when i try to execute the package, i'm getting the following error:

"Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection."

My connection string is like:

"Data Source=SQLServerName;Integrated Security=false;Initial Catalog=STG_DB;Provider=SQLNCLI10.1;Persist Security Info=True;Userid=uid;Password=pwd;Auto Translate=False;"

However, when I change the "Integrated Security=false" to "Integrated Security=SSPI", the package gets executed successfully..

I also verified that the following checkboxes are checked in the Component Services -> My Computer -> DTC -> Local DTC Properties.

"Network DTC Access"
"Allow Remote Client"
"Allow Remote Administration"
"Allow Inbound"
"Allow Outbound"

I'm using Windows 7.

Please let me know your suggestions in fixing this issue...




Post #1416242
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse