JMSM (1/30/2008)

---

[font="Arial"]Hello,

Can you tell me how can i give permissions for the execution of the xp_cmdshell to one user without give the sysadmin permission. This problem appears because theres an apicatioon(app user) that needs to execute some operating system task but i cant give this privilege to users.

I give the grant execution on the xp_cmdshell but it gives me the following error.

Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1

The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.

(0 row(s) affected)

Thanks and regards.

jmsm;)[/font]