B
B
biohazardvr2019-03-22 09:35:16
SQL Server
biohazardvr, 2019-03-22 09:35:16

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

1 answer(s)
D
d-stream, 2019-03-22
@d-stream

GRANT EXECUTE on xp_cmdshell to sql_user

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question