Azure SQL Azure AD 身份验证失败 [英] Azure SQL Azure AD Authentication Failure

问题描述

我正在尝试从我的 .NET 应用程序 (Sitecore) 连接到具有 Azure Active Directory 数据库包含用户的 Azure SQL 数据库.我在托管 .NET 应用程序的 VM 上安装了 adalsql.dll.但是，当我尝试连接时，我收到以下错误:

I am trying to connect to my Azure SQL Database that has a Azure Active Directory Database Contained User from my .NET Application (Sitecore). I have the adalsql.dll installed on the VM hosting the .NET Application. However, when I attempt to connect, I receive the following error:

无法在 Active 中对用户 [e-mail] 进行身份验证目录(身份验证=ActiveDirectoryPassword).错误代码0xCAA20064;状态 10 AADSTS50055:强制更改密码.

Failed to authenticate the user [e-mail] in Active Directory (Authentication=ActiveDirectoryPassword). Error code 0xCAA20064; state 10 AADSTS50055: Force Change Password.

这是我的连接字符串:

<add name="mydb" connectionString="Data Source=test.database.windows.net,1433;Initial Catalog=TEST_DB;Persist Security Info=False;User ID=[e-mail];Password=12345;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Authentication=Active Directory Password" />

推荐答案

重置用户密码成功了.进入 Azure Active Directory 并选择重置密码后，我必须登录 Azure 门户.

Resetting the user password did the trick. I had to login to the Azure Portal after going into Azure Active Directory and selecting reset password.

这篇关于Azure SQL Azure AD 身份验证失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！