question

shaikhshoaib-6404 avatar image
0 Votes"
shaikhshoaib-6404 asked ·

GMSA, MSA for SQL Server

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-general
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered ·

Hi @shaikhshoaib-6404,

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.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks this helps with my question

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered ·
· 3 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

thanks for your reply, this helps

0 Votes 0 ·

thanks
Would need to know the minimum forest/domain functional levels for MSA (not gmsa) for SQL 2014 in Windows 2016.

0 Votes 0 ·
Cathyji-msft avatar image Cathyji-msft shaikhshoaib-6404 ·

Hi @shaikhshoaib-6404,

Thanks for posting the issue on Q&A. This is a new issue, suggest you create a new thread for this issue. It will be better for others reading this thread. Thanks for your understanding.

Have a good day!

0 Votes 0 ·
shaikhshoaib-6404 avatar image
0 Votes"
shaikhshoaib-6404 answered ·

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

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.