question

Snamelisch avatar image
Snamelisch asked

Altering credential ##xm_cmdshell_proxy_account## for xp_cmdshell

Current situation We have - 2 SQL Server 2014 instances (including the latest service packs) - each on a different Window 2012R2 machines. - with each a different windows accounts for the ##xm_cmdshell_proxy_account##. On both systems the xp_cmdshell works completely fine. Important not: One account is: - the AD Administrator - and the other one is a normal Active Directory account with administrator privileges (lets call this one NormalAdmin). Change Because both are windows administrators we like to change them to non-administrator accounts. There has been created an new account for this goal. - It has rights to run applications on the places where it needs to - It has rights to access and modify files in the filesystem - It has access to the databases it needs to - The account is member of the master database - And is granted rights to run the xp_cmdshell command But: - It still cannot perform dir commands - Or run bat-files Questions Because all the steps mentioned in manuals have been taken, I am not able to make the question more clearer than: - So, what to do next?
xp_cmdshellexecutewindows-server-2012accountbatch
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.