ADF manual migration from dev instance to prod instance is getting failed with ARM template

kks8589 96 Reputation points

Hi All,
I am having issue when migrating ADF from one subscription to other subscription while migrating getting the below error


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,080 questions
{count} votes

1 answer

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 84,941 Reputation points Microsoft Employee

    Hello @kks8589 ,

    From the error message "Failed to encrypted linked service credentials on self-hosted IR 'SelfHostedIR', reason is: NotFound, error message is: No online instance"

    Make sure self-hosted IR is online, when you are deploying. Otherwise you may get this error message because self-hosted IR will be used to encrypt your payload.

    To encrypt the sensitive data from the JSON payload on an on-premises self-hosted integration runtime, run New-AzDataFactoryV2LinkedServiceEncryptedCredential, and pass on the JSON payload. This cmdlet ensures the credentials are encrypted using DPAPI and stored on the self-hosted integration runtime node locally. The output payload containing the encrypted reference to the credential can be redirected to another JSON file (in this case 'encryptedLinkedService.json').

    New-AzDataFactoryV2LinkedServiceEncryptedCredential -DataFactoryName $dataFactoryName -ResourceGroupName $ResourceGroupName -Name "SqlServerLinkedService" -DefinitionFile ".\SQLServerLinkedService.json" > encryptedSQLServerLinkedService.json  

    For more details, refer "Encrypt credentials for on-premise data stores in ADF".

    Hope this helps. Do let us know if you any further queries.


    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.