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. |
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.

Grant the Microsoft Entra Connect administrator and the domain service account the following permissions:
- SQL sign-in
- database owner(dbo) rights.

Next steps
@@ -18,9 +18,9 @@ To use this feature, you need to realize that there are several moving parts and |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](reference-connect-accounts-permissions.md).+|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](reference-connect-accounts-permissions.md).| |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.+|Microsoft Entra Connect administrator|Installs Microsoft Entra Connect and specifies the service account during custom installation.| <a name='steps-for-installing-azure-ad-connect-using-sql-delegated-permissions'></a> @@ -32,12 +32,12 @@ To provision the database out of band and install Microsoft Entra Connect with d 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.- +  2. Grant the Microsoft Entra Connect administrator and the domain service account the following permissions: - SQL sign-in - **database owner(dbo)** rights.- +  >[!NOTE]@@ -53,4 +53,4 @@ In case the SQL Administrator has restored ADSync database from a previous Micro ## Next steps - [Getting started with Microsoft Entra Connect using express settings](how-to-connect-install-express.md) - [Custom installation of Microsoft Entra Connect](how-to-connect-install-custom.md)-- [Install Microsoft Entra Connect using an existing ADSync database](how-to-connect-install-existing-database.md) +- [Install Microsoft Entra Connect using an existing ADSync database](how-to-connect-install-existing-database.md) 