Is this the correct group to post problems about proxy accounts?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Waldy - 27 Jul 2005 15:17 GMT

I have already posted this but have not received an answer.

Hi there,
I have set the proxy user details using
xp_sqlagent_proxy_account 'set' and the command completes successfully, so
the logon details are correct. I have also logged onto the server using
those details just to make sure and that works OK. However, when I fire a
trigger that is making a call to xp_cmd_shell, I get the message "Logon
failure: unknown user name or bad password" Anyone know what the issue is
here?

This is SQL Server 2000 SP3 on Windows 2000 SP4.

Reply to this Message

Sue Hoegemeier - 28 Jul 2005 01:41 GMT

Try resetting the proxy account using the user and password
you can log in with - the easiest way to reset is to select
the properties of SQL Server Agent, on the Job Control tab,
click on Reset Proxy Account.

-Sue

>I have already posted this but have not received an answer.
>
[quoted text clipped - 8 lines]
>
>This is SQL Server 2000 SP3 on Windows 2000 SP4.

Reply to this Message