Proxy account not working when logged off

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Proxy account not working when logged off

Proxy account not working when logged off

Rate Topic

Display Mode

Topic Options

Author

Message

jaco-550096

Posted Tuesday, February 26, 2008 1:51 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 15, 2012 4:34 AM
Points: 5, Visits: 27

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 ?

Post #460096

tracey.waycot

Posted Wednesday, May 21, 2008 3:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2008 5:40 AM
Points: 2, Visits: 7

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

Post #504298

jaco-550096

Posted Wednesday, May 21, 2008 3:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 15, 2012 4:34 AM
Points: 5, Visits: 27

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

Post #504302

tracey.waycot

Posted Wednesday, May 21, 2008 3:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, July 18, 2008 5:40 AM
Points: 2, Visits: 7

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

Post #504303

ALZDBA

Posted Wednesday, May 21, 2008 3:55 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:25 AM
Points: 6,861, Visits: 8,045

- 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

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

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

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

"press F1 for solution", "press shift+F1 for urgent solution" BigGrin

Need a bit of Powershell? How about this

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

Post #504317

jaco-550096

Posted Wednesday, May 21, 2008 4:29 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 15, 2012 4:34 AM
Points: 5, Visits: 27

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

Post #504336

ALZDBA

Posted Wednesday, May 21, 2008 5:00 AM

SSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 6:25 AM
Points: 6,861, Visits: 8,045

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

Johan

     Jul 13

Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere w00t

Need a bit of Powershell? How about this

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

Post #504350

jaco-550096

Posted Wednesday, May 21, 2008 5:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, June 15, 2012 4:34 AM
Points: 5, Visits: 27

The error message says 'The job has failed'. Nothing else.
However, when I schedule it to run again and just close the TS session, in stead of loggin off, it runs perfect. ???

Post #504356

« Prev Topic | Next Topic »

Permissions