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?