Replace service SQL service account with GMSA

Richard Y 486 Reputation points
2024-01-13T13:07:48.88+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,201 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,516 questions
Active Directory Federation Services
Active Directory Federation Services
An Active Directory technology that provides single-sign-on functionality by securely sharing digital identity and entitlement rights across security and enterprise boundaries.
1,219 questions
0 comments
Accepted answer
  1. Thameur-BOURBITA 32,621 Reputation points
    2024-01-13T13:12:32.81+00:00

    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

    1 person found this answer helpful.

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 105.8K Reputation points MVP
    2024-01-13T13:11:43.24+00:00
    1 person found this answer helpful.
  2. Azar 21,230 Reputation points MVP
    2024-01-13T13:12:19.1733333+00:00

    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.

    1 person found this answer helpful.
  3. Javier Villegas 900 Reputation points MVP
    2024-01-15T18:12:31.7666667+00:00

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

    1 person found this answer helpful.
    0 comments