Virtual Machine Management Service fails to start

Carl94580345 41 Reputation points
2026-11-17T19:25:47.0733333+00:00

report.txt I know the issue has something to do with denial of access to the SQL server. However, the service is reaching the SQL server.

System Center Virtual Machine Manager
0 comments No comments

1 answer

Sort by: Oldest
  1. AI answer

    2026-11-17T19:28:45.6633333+00:00

    Grant the SQL Server Database Engine service identity—not the VMM service account—AD authorization-read access by adding its effective domain principal to Windows Authorization Access Group, then restart SQL Server and VMM.

    Apply the fix

    The report shows that VMM successfully opened VirtualManagerDB, but SQL Server failed while resolving the Windows principal domain\SCVMM-DB:

    • SQL error 15404, state 19
    • Windows error 0x5 (Access denied)
    • VMM error SQLInsufficientPermissions (2607)

    VMM 2025 requires the SQL Server service to run under an identity that can access AD DS. A local user account is not supported for this purpose.^1^

    1. On the SQL Server, open SQL Server Configuration Manager.
    2. Select SQL Server Services.
    3. Open the properties of SQL Server (<instance>) and note the Log On As identity.
    4. Determine the AD principal that must receive access:
      • Domain account or gMSA: use that account, such as DOMAIN\SqlService.
      • Local System, Network Service, or a virtual account such as NT SERVICE\MSSQLSERVER: use the SQL Server computer account, DOMAIN\SQLSERVER$. Virtual accounts access network resources as the computer account.^2^
      • Local user: change it to an appropriate domain account, managed service account, or Local System because VMM specifically says not to use a local user.^1^
    5. In Active Directory Users and Computers:
      1. Enable View → Advanced Features if needed.
      2. Open the Builtin container.
      3. Open Windows Authorization Access Group.
      4. Add the effective SQL identity identified above.

    This group grants the account permission to read the dynamically calculated tokenGroupsGlobalAndUniversal authorization information used when resolving Windows users and groups.^3^

    1. During a maintenance window, restart:
      1. The SQL Server Database Engine service.
      2. The System Center Virtual Machine Manager service.

    Restarting SQL makes databases on that instance temporarily unavailable.

    Validate the referenced principal

    SQL error 15404 also occurs when the named Windows principal is invalid, misspelled, locked out, or cannot be trusted by the SQL service account’s domain.^4^

    Verify that:

    • domain\SCVMM-DB still exists in AD and is the intended user or group.
    • The effective SQL service domain account is not locked out.
    • If the SQL server, SQL service account, and SCVMM-DB principal are in different domains, the required trust exists. VMM requires a two-way trust when the VMM and SQL computers are in different AD domains.^1^
    • No explicit deny or hardened AD ACL prevents the SQL identity or Windows Authorization Access Group from reading authorization attributes.

    If the Windows Authorization Access Group itself no longer has its default TGGAU permissions, an AD administrator must restore those permissions or grant equivalent narrowly scoped read access.^3^

    If the SQL service identity must be changed

    Change it through SQL Server Configuration Manager, not services.msc; Configuration Manager also updates SQL-related permissions and protected settings.^5^

    After the change:

    1. Restart SQL Server.
    2. Confirm VirtualManagerDB is online.
    3. Start the VMM service.
    4. Confirm that no new SQL event 15404 is recorded.

    SPN repair is not the first action here: the captured failure is an AD authorization lookup denied inside an already-open SQL connection, rather than a failure to establish the SQL connection.


    References

    1. Plan VMM installation
    2. Configure Windows service accounts and permissions
    3. Some applications and APIs require access to authorization information on account objects
    4. MSSQLSERVER_15404 - SQL Server | Microsoft Learn
    5. SQL Server Configuration Manager
    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.