Access Dynamics 365 database from third party application

(0) Share

Report

Posted on by Zuteilunsgreif

Hi All!

I'm trying to access the SQL Server database behind our Dynamics 365 installation. There's a nice step-by-step guide how to do that here:

https://dynamics-chronicles.com/article/how-access-dynamics-365-online-sql-server-database

I followed all steps and can easily connect from SQL Server Management Studio. Very, very cool!
However when I try to use a third party app to go the same way to access the server, I get the attached error message, saying the this app must be preauthenticated somewhere. But I don't understand how to do that and what that means?

3312.ErrorMessage.png

Can someone point me in the right directions?
It looks like the app is submitting some kind of identifier that must be white listed somewhere?!

Thanks for all your help in advance,

Patrick

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

PerezAguiar Microsoft Employee on at

Like (0)

Report

RE: Access Dynamics 365 database from third party application

Hey!

Can you try switchin the "Active Directory - Password" for something like "azure MFA"? The other point, is that in these kind of situations, you should generate an Azure AD Appplication & Service Principal (https://learn.microsoft.com/en-us/azure/active-directory/develop/howto-create-service-principal-portal) and then add the application to the environment and provide the right permissions as documented on https://learn.microsoft.com/en-us/power-platform/admin/manage-application-users

Regards,

Was this reply helpful? Yes No