SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Ugh. SSIS Connection Manager Woes!


Ugh. SSIS Connection Manager Woes!

Author
Message
autoexcrement
autoexcrement
Old Hand
Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)

Group: General Forum Members
Points: 374 Visits: 777
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
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8555 Visits: 7660
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
autoexcrement
autoexcrement
Old Hand
Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)

Group: General Forum Members
Points: 374 Visits: 777
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
Evil Kraig F
Evil Kraig F
SSCrazy Eights
SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)SSCrazy Eights (8.6K reputation)

Group: General Forum Members
Points: 8555 Visits: 7660
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
Attachments
ProxiesNode.jpg (38 views, 13.00 KB)
RunAsInJobStep.jpg (39 views, 8.00 KB)
autoexcrement
autoexcrement
Old Hand
Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)Old Hand (374 reputation)

Group: General Forum Members
Points: 374 Visits: 777
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search