Solved

Failed to create proxy account

Posted on 2011-09-10
5
931 Views
Last Modified: 2012-05-12

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
Comment
Question by:motioneye
  • 2
  • 2
5 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 250 total points
ID: 36517663
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
 

Author Comment

by:motioneye
ID: 36517948
Hi,
I'm trying with multiple login but it still throw me with the same errors.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36517990
Are any of those logins the sysadmin?
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 36521781
what is you sql server version\edition\sp, please ?
did you login as  'sa' role member on this sql server ?
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points
ID: 36521787
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now