CODEWITHSUNDEEP
azuresitecoreazure-sql-databaseazure-active-directory
Kode
Kode

Reputation: 3225

Azure SQL Azure AD Authentication Failure

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:

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

Here is my connectionString:

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

Upvotes: 4

Views: 2209

Answers (1)

Kode
Kode

Reputation: 3225

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.

Upvotes: 1

Related Questions