Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

SQL MFA Authentication

(0) ShareShare
ReportReport
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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,642 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,371 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans