Always On Service Account gMSA
Running SQL Server under a managed service account.
Commands used in this video are below.
On a Active Directory Server run the following command:
New-ADServiceAccount -name SQLService -DNSHostName SQL-CLUSTER-001.lab.local -PrincipalsAllowedToRetrieveManagedPassword SQLA$,SQLB$ -ServicePrincipalNames MSSQLSVC/SQLA:1433,MSSQLSVC/AG:1433,MSSQLSVC/SQLB:1433
On the cluster nodes run the following commands:
Install-WindowsFeature RSAT-AD-PowerShell
Install-ADServiceAccount SQLService
Follow us on
Twitter - / tipsforitpros