Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Failed to acquire connection.. Expand / Collapse
Posted Thursday, February 14, 2013 5:10 AM
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'm 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'm using Windows 7.

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



Post #1419991
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse