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

Ugh. SSIS Connection Manager Woes! Expand / Collapse
Author
Message
Posted Friday, August 8, 2014 12:19 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 17, 2014 10:23 AM
Points: 156, Visits: 599
I'm new to SSIS.

I'm new to using Windows Authentication vs SQL Server Authentication.

Sorry, this is all going to sound terribly naiive.

If IT has set up a "Proxy Account" for me, how can I set up my SSIS package to use Windows Authentication but use that Proxy Account, instead of my own personal account which I use to log into the server?

We need this SSIS package to continue to run even if my personal Windows login is closed, if I leave the company for example.

Make sense?



"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura
Post #1601303
Posted Friday, August 8, 2014 12:23 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:43 AM
Points: 5,401, Visits: 7,512
autoexcrement (8/8/2014)

If IT has set up a "Proxy Account" for me, how can I set up my SSIS package to use Windows Authentication but use that Proxy Account, instead of my own personal account which I use to log into the server?

In the job step you setup, there's a line called Run As: (or something similar enough). Pick your proxy there.




- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
Post #1601304
Posted Friday, August 8, 2014 4:32 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 17, 2014 10:23 AM
Points: 156, Visits: 599
I've spent an insane amount of time on this. I'm sure there's an easy solution.

Apologies again for my ignorance, I'm just not seeing anything obvious here.

They are telling me I need to update the SSIS configuration to use the Proxy Account. Is that something easy to do? Any tips?

Just to clarify, this is Visual Studio 2005.



"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura
Post #1601346
Posted Friday, August 8, 2014 5:20 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:43 AM
Points: 5,401, Visits: 7,512
Wait, when you say proxy, what exactly do you mean? Do you mean they setup a proxy on the server like in the node below?



If so, you set that in the job step, like so:



If that's not what they're describing, can you help me understand what you mean by proxy?



- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA


  Post Attachments 
ProxiesNode.jpg (33 views, 13.09 KB)
RunAsInJobStep.jpg (33 views, 8.42 KB)
Post #1601357
Posted Thursday, August 14, 2014 3:56 PM


SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Friday, October 17, 2014 10:23 AM
Points: 156, Visits: 599
That is what they mean by proxy, but I'm just not seeing the RUN AS options when I try to create the SQL Agent job. Must be some permissions issue specific to their setup here. I'm trying to navigate the labyrinthine process of resolving this. Thanks for your time and efforts, I'll report back when I have news.


"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura
Post #1603493
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse