4,815 questions
How to fix Active Directory Interactive EntityCore exception?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 57.00000000000001%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
Hari Haran E
26
Reputation points
How to fix the following SQL Server? "Unhandled Exception: System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.ArgumentException: Cannot find an authentication provider for 'ActiveDirectoryInteractive'".
What are all the possible reasons that cause this exception ? How to resolve this?.
FYI: I have installed the ADAL package, I have set the Authentication=Active Directory Interactive in the connection string.
Developer technologies ASP.NET ASP.NET Core
SQL Server Other
14,494 questions
{count} vote
-
JamesTran-MSFT 36,906 Reputation points Microsoft Employee Moderator2023-07-06T17:11:14.1366667+00:00 Thank you for your post!
I understand that you're trying to fix an issue with your SQL server when it comes to Active Directory Authentication. To gain a better understanding of your issue and hopefully help point you in the right direction, I'll share some troubleshooting steps below.
If you're following this doc - Configure and manage Azure AD authentication with Azure SQL
- Is your domain's Active Directory federated with Azure Active Directory or is it a managed domain that is configured for seamless SSO for pass-through or password hash authentication?
- Is your application / service connecting to the database running on a domain-joined machine under a user's domain credentials?
- Can you ensure that your Connection String reflects what is shown in the documentation?
- When it comes to configuring your client computers, can you make sure you met all the requirements if you want to continue using ADAL.DLL in your applications?
Any additional information or screenshots would be greatly appreciated.
I hope this helps!
If you have any other questions, please let me know. Thank you for your time and patience throughout this issue.
If the information helped address your question, please Accept the answer. This will help us and also improve searchability for others in the community who might be researching similar information.
Sign in to comment
Sign in to answer