I can not create a linked service in Azure Data Factory

Question

Hi, I am trying to create a linked service in Azure Data factory but I can not. The connection is successful but can not create the linked service. The error I get is the following: Failed to encrypt sub-resource payload { "Id": "/subscriptions/174d468f-89a6-400e-8aec-d970c75b7e41/resourceGroups/Data_Factory-TUEV-GROUP-IT/providers/Microsoft.DataFactory/factories/DF-TUEVAUSTRIAGROUP/linkedservices/SqlServer2", "Name": "SqlServer2", "Properties": { "annotations": [], "type": "SqlServer", "typeProperties": { "connectionString": "********************" }, "connectVia": { "referenceName": "OnPremVio", "type": "IntegrationRuntimeReference" } } } and error is: Failed to encrypted linked service credentials on self-hosted IR 'OnPremVio', reason is: RequestTimeout, error message is: Request Timeout..

Answer 1

Hello Veizi Ioanna,

From the error message it seems like your source data  factory might have a non linked SHIR that you are using in your linked service. 

If this the case, you need to set SHIR in a ternary data factory and share it out and utilize linked SHIRs in the data factory where you export the templates

This is discussed at https://docs.microsoft.com/en-us/azure/data-factory/continuous-integration-deployment#best-practices-for-cicd.

I hope this helps.