Proxy account not working when logged off

Question

Proxy account not working when logged off

jaco-550096

SSC Journeyman

Points: 89
More actions
February 26, 2008 at 1:51 am

#203674

I have created a proxy account using credentials of a valid domain account with proper Windows and SQL permissions. This proxy account is used when SQL Server Agent Runs a job containing packages that imports data from outside the SQL Server.
Everything runs fine if the user on which the credentials is based is logged in, however when I log him off, the job fails.
Any ideas why, and what can be done ?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

tracey.waycot SSC Rookie Points: 36 More actions · Answer 1

I'm having the same issue - although some of the jobs work fine which is bizarre - have you had any response or ideas from anyone yet?

Cheers

jaco-550096 SSC Journeyman Points: 89 More actions · Answer 2

Hi;

None yet. I get a workaround in the sense that I have created a service account that stays logged onto the server always. Obviously when the server gets restarted for any reason, I need to log the service account in again.

Hope this helps

tracey.waycot SSC Rookie Points: 36 More actions · Answer 3

Ok thanks for this - will give that a try for now.

Johan Bijnens SSC Guru Points: 135255 More actions · Answer 4

- are you using (mapped) drive letters in your packages (file locations) ?

Use UNC !

don't use file = 'x:\myfolder\myfile.txt'

but use file='\\myserver.mydomain\myshare\myfolder\myfile.txt'

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

jaco-550096 SSC Journeyman Points: 89 More actions · Answer 5

Hi;

I'm not puling in textfiles. I am trying to access another server with an Oracle db on. I am doing this through Oracle client. All works fine as long as the account that is also the proxy account's credentials, is logged into the server,

Jaco

Johan Bijnens SSC Guru Points: 135255 More actions · Answer 6

What's the exact error you are receiving if the proxy is not logged in ?