Forum Discussion
What Synapse Serverless SQL pool authentication type for ADF Linked Service?
Hi, I'm relatively new to Azure Data Factory and require your guidance on how to successfully create/test a Linked Service to the Azure Synapse Analytics Serverless SQL pool. In the past, I've succ...
Hi D_PBI ,
Based on the information you provided, here are some of my insights:
- Select 'Azure Synapse Analytics' datastore: Yes, it is correct to select 'Azure Synapse Analytics' as the datastore when you want to extract data from the Azure Synapse Serverless SQL pool.
- Use AutoResolveIntegrationRuntime: If your Synapse source is in your domain and you are fully based on MS Cloud, then using 'AutoResolveIntegrationRuntime' is appropriate.
- Fill in the 'Fully qualified domain name' and 'Database name' fields: Ensure that you have correctly entered the Azure Synapse Analytics Serverless SQL endpoint in the 'Fully qualified domain name' field and the Azure Synapse Analytics Serverless SQL endpoint in the ' Database name' field.
- Select 'System-assigned managed identity' as the authentication type: This may be the problem. Although 'System-assigned managed identity' is a valid authentication type, it requires the managed identity to have the necessary permissions to access the Synapse SQL pool. You may need to try using SQL authentication or Microsoft Entra authentication.
Fore more details, you can refer to below document:
Microsoft Fabric, explained for existing Synapse users | Microsoft Fabric Blog | Microsoft Fabric
Managed identities for Azure - Azure Service Fabric | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous - thanks for your response. It's the confirmation I require.