运行sp_xp_cmdshell_proxy_account 出现的错误

运行sp_xp_cmdshell_proxy_account 存储过程可能出现以下几种错误：

sp_xp_cmdshell_proxy_account 'domain\account','p@5$word'

 

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: '0'.

---用户名称错误

 

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: '1326'.\

--密码错误

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'.

--access deny,用户缺少权限，无法调用底层dll。此出现在vista或windows 2008。禁用UAC或者以administrator权限运行可解决这个问题

转载于:https://www.cnblogs.com/stswordman/archive/2008/10/07/1305494.html