I am attempting to use xp_cmdshell using a proxy user, however even when configuring this user using sp_xp_cmdshell_proxy_account I see this error:
Msg 15137, Level 16, State 1, Procedure sp_xp_cmdshell_proxy_account, Line 1
An error occurred during the execution of sp_xp_cmdshell_proxy_account. Possible reasons: the provided account was invalid or the '##xp_cmdshell_proxy_account##' credential could not be created. Error code: 0(null), Error Status: 0.
When looking at the server properties to see the proxy account specified it is showing it there, but when I run exec xp_cmdshell 'whoami.exe'; it always shows:
nt service\mssql$sqlexpress
This leads me to believe that SQL Server Express does not support a proxy user. I cannot find anything online about this but it seems to be the case. Can someone please confirm this for me or perhaps offer a workaround?
I am using:
Microsoft SQL Server 2016 (SP1-GDR) (KB4505219) - 13.0.4259.0 (X64) Jun 15 2019 19:20:12 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows Server 2012 R2 Standard 6.3 <X64> (Build 9600: )
Thank you,
David
