Share via

Error in Linked Service connected to azure sql db using Azure Key vault

Sudip Bala 20 Reputation points
2024-05-09T15:16:14.0666667+00:00

User's image

The linked service is not working after performing CICD from dev to qa branch. All the resources are copied along with linked service. However, The linked service could not setup correctly with this error.

What does this error indicate and how to resolve this?

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,141 questions
Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,695 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marilee Turscak-MSFT 34,546 Reputation points Microsoft Employee
    2024-05-09T23:08:25.34+00:00

    Hi @Sudip Bala ,

    The error message indicates that there is no managed identity provisioned for the data factory. You can enable the managed identity via Azure CLI with this command:

    az resource update --name <factoryname> --resource-group <group-name> --namespace Microsoft.DataFactory --resource-type factories --set identity.type=SystemAssigned

    Let me know if this resolves the error and if you still run into any errors.