Symptoms

When creating a new ADF (Azure Data Factory) SQL data source with an on-prem SQL Server, running ODX Synchronization or Transfer tasks give the following error:

Microsoft.Rest.Azure.CloudException: Failed to encrypt sub-resource payload ..

Cause

Self-Hosted Integration Runtime is offline.

Resolution

Ensure your Self-Hosted Integration Runtime is online (connected to the cloud service) when executing ODX tasks for an ADF data source that requires it. Self-hosted IR is used to encrypt your payload.

More information

After the data source is successfully configured (ODX Synchronization or Transfer tasks succeeded), if you then stop the Self-Hosted Integration Runtime, you may get a more descriptive message:

The Self-hosted Integration Runtime <Name> is offline