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

Errors when Enable the SSIS Package Configuration - Conenction refused using SQL Authentication Expand / Collapse
Posted Sunday, January 10, 2010 12:30 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, January 15, 2016 5:34 AM
Points: 41, Visits: 559
Hi all

I have a problem when I use SSIS Package Configuration and Conenctions using SQL Authentication.

I develop simple to complex packages....but everything work in my machine and the conenctions in the connection manager use all SQL Authentication.

When package is ready, i decide to create package configurations for each of the conenctions in the connetion manager and deploy it to the server.

Well the problem start here....becasue as soon as i enable the package configuration and i run it again from my machine it does not work anymore.

The error is something like this:

error acquiring connectionmanager...etc...etc....the user do not have permission to connect with the database.

the problem goes away when i modify the connections to use windows authentication.

but if i use the windows authentication then when i deploy the package....the package fail becasue it will be executed by the SQL Service user account....which have minimal privilages...i guess...

If i remove the package configuration at all...WORK!!! even when deployed....

Anybody knows this problem?

I use OLEDB\Native SQL Server Client 10 or something like that....

Post #845095
Posted Thursday, August 2, 2012 8:51 AM



Group: General Forum Members
Last Login: Friday, November 4, 2016 4:42 AM
Points: 165, Visits: 654
Hi Sugnu,

I now your post is a little bit old but i´m facing the same situation right now and I would like to know if you resolved this issue and if so, how you did it.

Kind Regards,


Paul Hernández
Post #1339237
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse