Forum Discussion
Fabric user/password authentication
Hello,
How can I connect to Fabric using username/password without an interactive login?
My application uses a backend connection, so I need to connect to Fabric using a username and password.
I can't use a dialog box or any interactive login to provide credentials.
It possible to perform this kind of authentication programmatically?
If yes, how can I set it up?
Thank you all.
Best regards,
Daniela
Hi danielaboamba,
Basic auth is not possible into Fabric itself, either you need to follow the oauth flow with a user account, or you need to use a service principal.
See Microsoft Fabric security fundamentals - Microsoft Fabric | Microsoft Learn
Can you provide more detials on what you're trying to do?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.Hi danielaboamba - I'm Dave from the SQL Drivers team. Great to meet you!
Your best bet for this scenario is Service Principal Authentication. It gives you the ease of a SQL login but mitigates most of the security risks. Active Directory Password Authentication is another option that works pretty much the same way but we are working on deprecating that option and ask that you not use it.
Hope that helps!
Dave
Hi danielaboamba,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
dlevy & tayloramy ,Thanks for your prompt responseThank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support
5 Replies
Hi danielaboamba - I'm Dave from the SQL Drivers team. Great to meet you!
Your best bet for this scenario is Service Principal Authentication. It gives you the ease of a SQL login but mitigates most of the security risks. Active Directory Password Authentication is another option that works pretty much the same way but we are working on deprecating that option and ask that you not use it.
Hope that helps!
Dave
Hi @danielaboamba,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
Thank you for your patience and look forward to hearing from you.
Prashanth Are
MS Fabric community supportI mean It possible to perform this kind of authentication using user/password?
Hi danielaboamba,
Basic auth is not possible into Fabric itself, either you need to follow the oauth flow with a user account, or you need to use a service principal.
See Microsoft Fabric security fundamentals - Microsoft Fabric | Microsoft Learn
Can you provide more detials on what you're trying to do?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Hi danielaboamba,
We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.
dlevy & tayloramy ,Thanks for your prompt responseThank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support