For a very long time, our main SQL account has been a thorn in the side of those of us in security, but we finally may have a chance here, which is why I've come here.
Our SQL environment is a mix of SQL 2008 R2, 2012 and 2016 (most 2012 or newer). Ideally, I'd like to move toward a gMSA, which I know is only supported on 2014/2016.
Does anyone have any recommendations as to the best way to set this up on the security side? I do not think we'll get a chance at a major change for this again, so I want to get as much as possible now. They'd want the account to be able to run jobs and tasks as well as SQL services.