Is this the correct group to post problems about proxy accounts?
From: Waldy (waldy_at_notmail.com)
Date: 07/27/05
- Next message: Simn: "Can run sp as Administrator but not as User/dbo"
- Previous message: Rog: "Need Advice - encrypt data in transit"
- Next in thread: Sue Hoegemeier: "Re: Is this the correct group to post problems about proxy accounts?"
- Reply: Sue Hoegemeier: "Re: Is this the correct group to post problems about proxy accounts?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 27 Jul 2005 15:17:40 +0100
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.
- Next message: Simn: "Can run sp as Administrator but not as User/dbo"
- Previous message: Rog: "Need Advice - encrypt data in transit"
- Next in thread: Sue Hoegemeier: "Re: Is this the correct group to post problems about proxy accounts?"
- Reply: Sue Hoegemeier: "Re: Is this the correct group to post problems about proxy accounts?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
