sp_xp_cmdshell_proxy_account error
- From: t2581@xxxxxxxxxxx
- Date: 11 Oct 2006 08:54:44 -0700
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
.
- Prev by Date: Re: SPN Requirement
- Next by Date: Re: Login Failure
- Previous by thread: Re: SQL to get a list of users/roles/permissions
- Next by thread: SQL Profiler question
- Index(es):
Relevant Pages
|