An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
hi Surendra Yadav & thx for sharing urs issue here at Q&A portal,
Error 9054 usually means Synapse can’t reach the Integration Runtime path used for the linked service test.
For an Azure Key Vault linked service, this is usually one of these: IR issue, Key Vault firewall/private endpoint/DNS, or missing managed identity permission. Since the dialog says Failed to connect to Integration Runtime or connection is broken unexpectedly, I’d check the IR first. If u use AutoResolve IR, try changing the region or create a dedicated Azure IR in the same region as Synapse/Key Vault. If u use self-hosted IR, make sure the node is online and can reach Key Vault over HTTPS. Then check Key Vault networking. If public access is disabled or selected networks is enabled, Synapse needs a valid network path. With Synapse managed VNet, create a managed private endpoint to Key Vault and approve it on the Key Vault side. DNS must resolve the vault to the private endpoint.
Don’t forget permissions. The Synapse workspace managed identity needs access to Key Vault secrets. Depending on ur Key Vault mode, grant either RBAC like Key Vault Secrets User, or access policy with Get and List secrets.
Key Vault RBAC https://learn.microsoft.com/en-us/azure/key-vault/general/rbac-guide
For support, include the Activity ID from the error 5d91978f-48d7-4a99-9cdd-d1ba39cca24c
I guess its not a broken linked service definition. More likely Synapse IR can’t reach the vault because of firewall/private endpoint/DNS, or the workspace MI can reach it but lacks secret permissions.
rgds,
Alex
&
If my answer was helpful pls mark it and additional thx if u follow me at Q&A portal
and at my blog https://ctrlaltdel.blog/