Forum Discussion
issue with Permission to sql end point
I have a user that I have given a contribution role, but they cannot query the sql end point.
I get below error
Hi JuanGabriel,
To connect to a SQL endpoint you need to use Microsoft Entra MFA, not integrated security.
see Warehouse Connectivity - Microsoft Fabric | Microsoft Learn
and
Microsoft Entra Authentication in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
3 Replies
- tayloramy
Super User
Hi JuanGabriel,
To connect to a SQL endpoint you need to use Microsoft Entra MFA, not integrated security.
see Warehouse Connectivity - Microsoft Fabric | Microsoft Learn
and
Microsoft Entra Authentication in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
v-echaithraCommunity Support
Hi JuanGabriel ,
Thank you tayloramy for your inputs.I hope the information provided is helpful. Please let us know if you have any further issues, we are happy to help.
Thank you.- v-echaithra
Hi JuanGabriel ,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.