News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics 365 | Integration, Dataverse... SQL MFA Authentication

Microsoft Dynamics 365 | Integration, Dataverse...

Unanswered

SQL MFA Authentication

(0) Share

Report

Report

Posted on by MBaba

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.

All responses Img

All responses (2)

Answers Img

Answers (0)

MBaba 92 on at

Like (0)

Report

RE: SQL MFA Authentication

Hello Eiken ,

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 on at

Like (0)

Report

RE: SQL MFA Authentication

Hi,

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,371 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Get batch job history log from D365 FO to Power Automate

Product updates

Dynamics 365 release plans