MS SQL Server - xp_cmdshell and proxy account

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

xp_cmdshell and proxy account

Bryan

2006-03-14, 1:23 pm

I am trying to set up permissions for users to run a procedure that calls
xp_cmdshell via proxy account. I set up the domain proxy account as a member
of the local administrators group and added to SQL Server as sysadmin. I even
went as far as adding it to master and granting execute permissions on
xp_cmdshell. I set the proxy account to also run the SQL Server Agent.
Additionally, I checked to make sure all databases are owned by ‘sa’ and that
I was able to log in using the account and run the procedure in question.
If I log in as a user through via NT Group, and run the procedure that calls
the xp_cmdshell, it does not use the proxy account. Why is this not working?

--
BB_DBA

Sponsored Links