I'm thinking about using MSA (or gMSA) as proxies inside my SQL Server instances. This proxies would be used for example for running SSIS packages or xp_cmdshell
command.
But based on what I've gathered there was a problem with using managed accounts inside credentials, because there was no way of providing password during creation of such credential.
Here is an old thread about SQL Server 2014: SQL Server 2014: Using gMSA for xp_cmdshell Proxy Account?
Few years have passed since then and I wonder if anything has changed and is there a way of creating proxies with managed accounts?
And if there isn't a way - what is currently considered "best practice" in creating such proxies? Does use of domain user instead of MSA is a good idea? Or maybe there is a way to abandon proxies altogether?
I don't know if I'm correct in my thinking but after an extensive search in world wide webs it seems like integrating SQL Server with a domain is looked over by most and not much information can be found.