Answer the question
In order to leave comments, you need to log in
What is the correct way to call sp_xp_cmdshell_proxy_account?
How to run xp_cmdshell under a non-ms sql server account?
SQL works on nt authority\network service, the xp_cmdshell 'whoami.exe' command actually returns exactly this account.
I sit under the administrator (both servers and sql) I
install proxy
EXEC sp_xp_cmdshell_proxy_account 'domen\user','passw';
No errors, completed successfully.
I call xp_cmdshell 'whoami.exe' - gives nt authority\network service.
How to work under domain\user?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question