Symptoms
When creating a new ADF (Azure Data Factory) SQL data source with an on-prem SQL Server, running Ingest Instance 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 Ingest Instance tasks for an ADF data source that requires it. Self-hosted IR is used to encrypt your payload.
Notes
After the data source is successfully configured (Ingest Instance 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
