sp_xp_cmdshell_proxy_account error



Hi
I have 2 sql2005 servers

on my desktop (wmtm123456)and on remote (mtl\sql123)
login to both servers with domain account and sa privelage (mtl\dba)


login with mtl\dba to server mtl\sql123

run

EXEC sp_xp_cmdshell_proxy_account 'mtl\test', 'Test123';



Msg 15137, Level 16, State 1, Procedure sp_xp_cmdshell_proxy_account,
Line 1
An error occurred during the execution of sp_xp_cmdshell_proxy_account.
Possible reasons: the provided account was invalid or the
'##xp_cmdshell_proxy_account##' credential could not be created. Error
code: '5'.


login with mtl\dba to desktop (wmtm123456)

run

EXEC sp_xp_cmdshell_proxy_account 'mtl\test', 'Test123';

success

what could be the problem ?
whete to get error description for Error code: '5'. (is it operation
system error?)



I am dba on both server and local admin of my desktop.

Thanks
Alex

.



Relevant Pages

  • Event ID 1219
    ... servers, and people can't login with their domain account. ... Sometimes a reboot doesnt help at all. ...
    (microsoft.public.windows.terminal_services)
  • Re: Linux authentication via AD
    ... Primarily I need to integrate Linux ... servers, but I do have a few OpenBSD servers. ... > a way to do this under older AIX) allows people to login authenticating ... > text passwords authenticate to the Windows Password Server as well. ...
    (comp.os.linux.security)
  • Re: Update site?
    ... The reason I needed to login from the same machine is - ... > Users by default are NOT allowed to logon to servers. ... You can change this in the Domain Security Policy I ... there open Domain Controller security policy. ...
    (microsoft.public.exchange.admin)
  • Domain Issues (Windows 2003)
    ... servers to this domain and can logon to them with a domain account. ... Some worked fine and I was able to login with domain accounts, ...
    (microsoft.public.windows.server.setup)
  • LDAP password authentication/modification schemes
    ... We are considering using LDAP to replace NIS+. ... SSL to encrypt the client to LDAP server transactions. ... authentication would be required for login, ... understand the servers responses and/or provide the appropriate responses to ...
    (comp.sys.hp.hpux)