I am facing issues while accesssing Fabric SQL endpoint from Azure Synapse Analytics using Managed IdentityLinked service configuration can be found belowError details:Granted access to Managed identity of Azure Synapse Analytics and shared all data in SQL endpoint using below method.Is there any possible reason why this is happening?

Hi Avadh , Thank you for reaching out to the Microsoft Community Forum. This is likely cause your Synapse workspace's system assigned managed identity doesn’t have the required item-level permission on the Fabric Lakehouse. Microsoft Fabric requires that any identity, including managed identities be explicitly granted access to the Lakehouse itself, not just at the workspace level. Go to Manage access in your Lakehouse and manually add the object ID of your Synapse managed identity. Assign it the Read all SQL endpoint data permission. Without this, the authentication will fail, even if everything in your linked service is configured correctly. Also, the red cross on AutoResolveIntegrationRuntime in your screenshot is a non-blocking UI status issue. Since you're using a managed identity, IR health doesn't impact authentication in this context and can be ignored, it doesn't affect authentication when using managed identity. Manage access for SQL databases in Microsoft Fabric with workspace roles and item permissions | Microsoft Fabric Blog | Microsoft Fabric Give Users Access to Workspaces - Microsoft Fabric | Microsoft Learn Workspace roles and permissions in lakehouse - Microsoft Fabric | Microsoft Learn What is the SQL analytics endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn

Accessing Fabric SQL endpoint using managed identity from Azure Synapse Analytics

Forum Discussion

Related content

SQL Analytics Endpoint

Lakehouse SQL endpoint access

Accessing SQL Analytics Endpoint via .NET API

Lakehouse SQL analytics endpoint logs

Lakehouse SQL Analytics Endpoint no longer connecting