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 Proxy/Credential usage - Encountering issues Expand / Collapse
Author
Message
Posted Thursday, March 13, 2008 9:43 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 04, 2014 11:08 AM
Points: 7, Visits: 158
Hi, I have a typical ETL scenario where we load data from text files to the database. A SQL standard login has been created with elevated rights and a stored procedure uses this login (EXECUTE AS) to start a job. The SQL login has proper SQLAgent groups assigned.

I have also created a credential and a proxy and the job steps run using this proxy. The problem is that unless I make the windows account that the creadential is based upon, a local administrator, my jobs keep on failing. As soon as the credential windows account is made the local admin, everything works fine.

How exactly are proxies and credentials to be used? What kind of permissions or group memberships does the credenital windows account need?

Thanks for any help

-Shishir
Post #468840
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse