GMSA, MSA for SQL Server

shaikh shoaib 171 Reputation points
2021-03-17T05:24:37.04+00:00

Need to find out if I can configure managed service account to run SQL server and agent services?
I know GMSA is not available for 2008 r2 with SQL 2008 R2, is MSA an option?
How about Windows 2012 and SQL 2012 (and R2 versions as well)
Thanks

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,321 questions
0 comments No comments
{count} votes

Accepted answer
  1. CathyJi-MSFT 21,126 Reputation points Microsoft Vendor
    2021-03-18T07:24:05.04+00:00

    Hi @shaikh shoaib ,

    > I know GMSA is not available for 2008 r2 with SQL 2008 R2, is MSA an option?

    No, SQL 2008 R2 not supported for MSA. SQL Server 2012 or higher is required to support the use of MSAs. And Windows Server 2008 R2 or higher is required to supported the use of MSA..

    Microsoft SQL Server 2014 is the first version to supports GMSAs. To use a GMSA for SQL Server 2014 or later, the operating system must be Windows Server 2012 R2 or later. Servers with Windows Server 2012 R2 require KB 2998082 applied so that the services can log in without disruption immediately after a password change.

    > How about Windows 2012 and SQL 2012 (and R2 versions as well)

    Windows 2012 and SQL 2012 are supported to use MSA.


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.


2 additional answers

Sort by: Most helpful
  1. Tom Phillips 17,721 Reputation points
    2021-03-17T13:47:20.46+00:00
    1 person found this answer helpful.

  2. shaikh shoaib 171 Reputation points
    2021-03-22T03:35:06.167+00:00

    All good, found out GSMA - domain level 2012 for MSA 2008 R2.

    0 comments No comments