I have a store procedure that runs the xp_cmdshell with a user with sysadmin right.(it was created by someone else long time ago). For securities purposes I need to remove the sysadmin right from this user. So I created a proxy account and gave execute to this user on the xp_cmdshell (practically followed the steps how to run xp_cmdshell with a non sysadmin user ). But when I run the store procedure I am getting the below error:
error number 15466 severity 16 errorline 1 An error occurred during decryption.
I use sql server 2008
i dont know what i am missing, pls help