Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Unanswered

SQL MFA Authentication

Posted on by 92

Hello,

I created an Azure function app using C# and fetched my data using SQL queries. I am facing a problem connecting with the SQL server with an MFA-enabled account. I tried to use several ways and will add the links below. Each time I tried a way to connect I get an error.

c# - How to connect to a database using Active directory Login and MultiFactor Authentication (MFA) - Stack Overflow

Connect to Dynamics 365 Multi-Factor Authentication using C# | Check this Guide Now (dynamics365book.com)

If anyone has figured out a way to connect to the SQL server in C# please help me out.

Thank you in advance.

  • MBaba Profile Picture
    MBaba 92 on at
    RE: SQL MFA Authentication

    Hello Eiken ,

    pastedimage1681722749435v2.png

    This is the error I am getting when trying to create an SQL connection with MFA enabled account. I am trying to find a way to use this account without removing the multi-factor authentication.

  • Eiken Profile Picture
    Eiken on at
    RE: SQL MFA Authentication

    Hi,

    Would you please provide some details or screenshots about the error?

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,349 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,212 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans