[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 997
  • Last Modified:

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.
0
motioneye
Asked:
motioneye
  • 2
  • 2
2 Solutions
 
Kevin CrossChief 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

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now