Fix GMSA on SQL Server

asked 2021-04-22T09:11:02.137+00:00
Kruto 96 Reputation points

I configure my sql servers to work with GMSA users for each service.
Then the DBA did changes with the configurations and change the service to his user.
I change back the services to the GMSA accounts but now after every restart I see an error :
The MSSQLSERVER service was unable to log on as GMSA with the currently configured password due to the following error: The user name or password is incorrect.

Regards,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,453 questions
{count} votes

Accepted answer
  1. answered 2021-04-26T06:31:36.537+00:00
    Kruto 96 Reputation points

    Thank you @CarrinWu-MSFT I found the solution in one of the comments.
    In My case it was changing the registry for all services who uses GMSA.

    I could not find this because I did not have the values on the working server .

    Registry :
    Key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services*Service Name*
    Value: ServiceAccountManaged
    Datatype: REG_BINARY
    Value :01 00 00 00

    No comments

0 additional answers

Sort by: Most helpful