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
Author
Message
Posted Tuesday, February 05, 2013 10:37 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, February 10, 2014 2:37 AM
Points: 237, Visits: 98
Hi,

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...

Thanks.
Ganesh




Regards,

Ganesh

Post #1416242
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse