Replace service SQL service account with GMSA

Question

Hi Everyone, Is it possible to replace SQL service accounts with GMSA?

Answer 1

Hi @Richard Y

Yes it's possible. I invite you to read the following Microsoft article talking about SQL service account:

Managed service accounts, group-managed service accounts, and virtual accounts

---

Please don't forget to accept helpful answer

Answer 2

Yes. Since I have no reason to work with gMSA myself, I googled gMSA SQL Server. The two top hits looks very promising.

https://www.mssqltips.com/sqlservertip/5340/using-group-managed-service-accounts-with-sql-server/

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16

Answer 3

Hi Richard Y I guess its possible to replace SQL Server service accounts with a GMSA. To do this, you'd start by creating a GMSA in Active Directory, install it on the server running SQL Server, and then configure the SQL Server service. after this restart the SQL Server service after making changes. If this helps kindly accept the answer thanks ,much.

Answer 4

Hi Richard, I do confirm that you can use GMSA as sql service account. We have it on every SQL VM Regards Javier