Help

[Bell1991]

I am attempting to set up a user to be able to run a stored procedure that executes xp_cmdshell. The only way currently i can currently do this is to have that user a member of the sys admin group. I have tried to grant the user execute rights to the xp_cmdshell and it still does not work. I think i have something set up wrong. I read that you can set up the xp_sqlagent_proxy_account using: xp_sqlagent_proxy_account set and but the problem is out server is not on a domain and it needs a domain account. Is there something i am doing wrong? Is there another way to do this?

Thanks
-Bell

 

[TheBugSlayer]

If you are a sys admin try GRANT EXECUTE ON User, where user is either a Windows domain user or a SQL server user login.