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中验证用户test@mytest.onmicrosoft.com 目录(Authentication = ActiveDirectoryPassword).错误代码 0xCAA20064;状态10 AADSTS50055:强制更改密码.
Failed to authenticate the user test@mytest.onmicrosoft.com in Active Directory (Authentication=ActiveDirectoryPassword). Error code 0xCAA20064; state 10 AADSTS50055: Force Change Password.
这是我的connectionString:
Here is my connectionString:
<add name="mydb" connectionString="Data Source=test.database.windows.net,1433;Initial Catalog=TEST_DB;Persist Security Info=False;User ID=test@mytest.onmicrosoft.com;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屋!