Failed to acquire connection..

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Failed to acquire connection..

Failed to acquire connection..

Rate Topic

Display Mode

Topic Options

Author

Message

ganeshc27

Posted Thursday, February 14, 2013 5:10 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, April 08, 2013 6:29 AM
Points: 214, Visits: 87

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

Regards,

Ganesh

Post #1419991

« Prev Topic | Next Topic »

Permissions