Failed to create proxy account


When I execute procedure Procedure sp_xp_cmdshell_proxy_account , it return me an error like below. How do I troubleshoot this kind of errors ?

EXEC sp_xp_cmdshell_proxy_account 'etys\sqlprox', 'BewRU';

Msg 15466, Level 16, State 2, Procedure sp_xp_cmdshell_proxy_account, Line 1
An error occurred during decryption.
motioneyeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Hi, motioneye, it is likely a permissions issue. You will need CONTROL SERVER permissions. Additionally, others have noted other concerns with security here:
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/08/23/xp-cmdshell-and-permissions.aspx

Hopefully this helps!
0
 
motioneyeAuthor Commented:
Hi,
I'm trying with multiple login but it still throw me with the same errors.
0
 
Kevin CrossChief Technology OfficerCommented:
Are any of those logins the sysadmin?
0
 
Eugene ZCommented:
what is you sql server version\edition\sp, please ?
did you login as  'sa' role member on this sql server ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.