We've attempted to apply user-assigned managed identity authentication from ADF to Synapse, and this works fine.
However, in a "copy data" activity, where the source is Synapse but the sink is an on-prem DB (using a self-hosted integration runtime), we get the following error:
Managed identity credential is not supported in this version ('5.7.7851.1') of Self Hosted Integration Runtime.
That IR is set to auto-update, so I'd assume it's on the latest version. This appears to be an oversight from Microsoft in releasing a feature that doesn't cover all the scenarios. Is there any idea as to when this problem may be resolved?
Another issue we're faced with is that the setting of the user-assigned managed identity is not parameterized within the generated ADF ARM template. That, coupled with the fact that Synapse does not allow duplicate identity names when creating SQL users on different subscriptions but the same tenant, is clearly problematic.
How could this be solved?
Regards,
Razeen.

