sql sp_xp_cmdshell_proxy_account error

Question

when I run the following command in sql on ly local PC:

EXEC sp_xp_cmdshell_proxy_account 'pc-name\my_username', 'password'

I'm getting the error:

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

This user I'm using when I login into windows and I'm logging to sql server(on my local pc) using windows authentication.

Should I create another user?

PS: from services, on SQL Service Agent Log On, I've set this user.

Answer 1

http://www.msbicoe.com/post/2011/12/27/The-Problem-of-xp_cmdshell_proxy_account-credential-could-not-be-created.aspx

Right click, run As Administrator - to open your SQL Query Management studio.