Microsoft Entra ID
General

Connect Install Sql Delegation

In brief

Corrected table-row formatting and link markup in the Microsoft Entra Connect SQL delegation documentation.

What Entra admins need to know

No administrator action is indicated.

This editorial summary was generated by AI from the documentation changes. Verify important details in the full Microsoft Learn article.

Documentation change

The comparison below shows only the changed extract. Use the full-page view for complete context.

Role Description
Domain or Forest AD administrator Creates the domain level service account that is used by Microsoft Entra Connect to run the sync service. For more information on service accounts, see Accounts and permissions.
SQL administrator Creates the ADSync database and grants login + dbo access to the Microsoft Entra Connect administrator and the service account created by the domain/forest admin.
Microsoft Entra Connect administrator Installs Microsoft Entra Connect and specifies the service account during custom installation.

  1. Have the SQL Administrator create the ADSync database with a case insensitive collation sequence (Latin1_General_CI_AS). The recovery model, compatibility level, and containment type are updated to the correct values when Microsoft Entra Connect is installed. However, the SQL Administrator must set the collation sequence correctly. Otherwise, Microsoft Entra Connect blocks the installation. To recover the SA must delete and recreate the database.

    Collation

  2. Grant the Microsoft Entra Connect administrator and the domain service account the following permissions:

    • SQL sign-in
    • database owner(dbo) rights.

    Permissions

Next steps

Daily Entra.News

Get daily email updates

Get a concise summary of the latest Microsoft Entra updates delivered straight to your inbox.

Loading the secure signup form…