I'm the same person who wrote that answer, the status has not changed.
sp_xp_cmdshell_proxy_account - group managed service account
Hi,
I would like to configure sp_xp_cmdshell_proxy_account using a group managed service account.
My searching have lead me to this thread that describes SQL server 2014:
https://dba.stackexchange.com/questions/187893/sql-server-2014-using-gmsa-for-xp-cmdshell-proxy-account
Now - has the status changed for SQL server 2017 / 2019 ?
-
Sean Gallardy - MSFT 1,901 Reputation points Microsoft Employee
2021-01-20T02:26:41.473+00:00
1 additional answer
Sort by: Most helpful
-
AmeliaGu-MSFT 14,001 Reputation points Microsoft External Staff
2021-01-20T05:27:21.96+00:00 Hi @agepeder ,
Based on my test, it seems we still cannot use a gMSA as the proxy account for xp_cmdshell in SQL Server 2017/2019 as SeanGallardy mentioned. With gMSAs, the password is managed by either the server using the account or by the AD DCs themselves. But the sp_xp_cmdshell_proxy_account is required to specify a Windows login and Password.I recommend you submit it to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server. Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.
Best Regards,
Amelia
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.