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

Errors when Enable the SSIS Package Configuration - Conenction refused using SQL Authentication Expand / Collapse
Author
Message
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: Monday, July 21, 2014 4:24 AM
Points: 41, Visits: 512
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....

Thanks
Post #845095
Posted Thursday, August 2, 2012 8:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, August 18, 2014 5:26 AM
Points: 119, Visits: 483
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


Paul Hernández
http://hernandezpaul.wordpress.com/
https://twitter.com/paul_eng
Post #1339237
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse