Blog Post

Azure Synapse Analytics Blog
3 MIN READ

ADF to Synapse Pool: Please enable Managed Service Identity and try again

Liliam_C_Leme's avatar
Liliam_C_Leme
Icon for Microsoft rankMicrosoft
Oct 26, 2020
Again quick post about error and mitigation. So as it is publicly documented ( today, Oct - 2020) managed identities are not currently supported on the SQL Pools under Synapse workspace. I mentione...
Updated Dec 10, 2020
Version 2.0
Synapse Administration
Synapse Pipelines
wiassaf's avatar
wiassaf
Icon for Microsoft rankMicrosoft
Jun 15, 2022

To followup: The "Allow Pipelines" step is no longer necessary. The system assigned managed identity (SA-MI) of the workspace is a member of the Synapse Administrator role and thus has elevated privileges on the dedicated SQL pools of the workspace.