none
Does SQL Server 2014 support Group Managed Service Accounts for an AlwaysOn Availability Group?

    Question

  • Does SQL Server 2014 support Group Managed Service Accounts for an AlwaysOn Availability Group?

    Friday, June 13, 2014 9:02 AM

Answers

  • Hi glasgowdan,

    As the new features of Windows Server 2012, Group Managed Service Account (gMSAs) is one account that can be used by multiple servers. We can use gMSA in SQL server 2012 standalone,  it works fine. However in AlwaysOn Availability Groups, it act a little weird. As other post, we will consider to support gMSA in future SQL Server release. For more information, you can review the detail about Group Managed Service Accounts.

    http://joeydantoni.com/2012/12/14/group-managed-service-accounts/

    In SQL Server 2014 official document, we can configure the accounts to run as a built-in account, such as Local System, Local Service, or Network Service, or a non-domain account, you must use certificates for endpoint authentication. If your service accounts are using domain accounts in the same domain, you can choose to grant CONNECT access for each service account on all the replica locations or you can use certificates. It is not introduced Group Managed Service Accounts in AlwaysOn Availability Groups.

    Regards,
    Sofiya Li


    Sofiya Li
    TechNet Community Support

    Monday, June 16, 2014 7:03 AM
    Moderator

All replies