Connection string to access Dynamics 365 (SQL Server) from an outside app

(2) Share

Report

Posted on by lesotho_kid

Hello,

We have a C# application which we have previously used to connect directly to the Dynamics 365 underlying SQL Server database.

We used a standard connection string which worked

Server=server name; Authentication=Active Directory; Password; Encrypt=True; Database=db name; User Id=ID name; Password=password text

We now connect via authentication type - "Azure Active Directory - Universal with MFA" but cannot figure out how to get the connection string to work. DB connection from C# app now fails. Any ideas how to structure the db connection string to work with this new authentication type?

Thanks,

Dan

Categories:

Dynamics 365 general

I have the same question (0)

All responses (1)

Answers (0)

AR-01121610-0 4,965 Moderator on at

Like (0)

Report

Connection string to access Dynamics 365 (SQL Server) from an outside app

Hy,

which D365 application you are using?

If Finance/Supply Chain/Commerce this will not work in this way.

More on that Integration between finance and operations apps and third-party services - Finance & Operations | Dynamics 365 | Microsoft Learn

Hope this helps.

Was this reply helpful? Yes No