I
I
ITF2019-08-21 20:54:02
Active Directory
ITF, 2019-08-21 20:54:02

Why is there an "Access Denied" error when connecting a gMSA account?

I want to run SQL server under a domain account.
AD Server(Server 2012 R2): Dom
Domain: my.example
SQL Server(MSSQL 2008 R2: MySQLServer - it's in the domain. I
created a KDS key.
I create a gMSA record:

New-ADServiceAccount -Name SQLService -DNSHostName dom.my.example -PrincipalsAllowedToRetrieveManagedPassword MySQLServer$ -Enabled $true

As I understand it, I immediately set the account binding to the server.
Read what is better to do
ADD-ADComputerServiceAccount -identity MySQLServer -ServiceAccount SQLService

(I tried both with and without this line)
Actually, then on the SQL server itself I log in under the domain administrator account and write:
Install-ADServiceAccount -identity SQLService
What I get is the error: Unable to install the "Access Denied" service account. A process has requested access to an object, but access rights have not been granted.
It
Test-ADServiceAccount -identity SQLServicereturns True
MS SQL Server 2008 R2
What am I doing wrong?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
I
ITF, 2019-08-21
@ITF

Deleted and recreated the account.
I thought that it might take time for the policies to be applied on the remote machine and restart the SQL server.
Install was successful.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question