Forum Discussion
Unsuccessful Silent Connection to SQL Endpoint
Hello Fabric Community, I hope this message finds you well. I'm reaching out because I've encountered a roadblock in establishing a silent connection to the SQL endpoint within Fabric. Despite being...
Hi Omar_Osman ,
Base on your description, it sounds like you're experiencing an issue with establishing a silent connection to a SQL endpoint within Fabric. Could you please check or try the following info?
1. Check if have been granted the proper permission
- Check the required scope (it could be Dashboard.ReadWrite.All or Dashboard.Read.All) and whether admin consent is required.
- Token: You could use JWT.io to decode the token to check the aud and permissions.
- Check if the client ID and client secret you're using are correct and authorized to access the SQL endpoint. And verify that the authority URL is correct and that the tenant ID is properly
2. Use a service principal or managed identity for authentication instead of a user account. This would allow for a more streamlined and automated connection process.
- Create a Microsoft Entra app and service principal in the portal
- Configure Microsoft Entra authentication - Azure SQL Database & SQL Managed Instance & Azure Synapse Analytics
Best Regards