AADSTS50158: External security challenge not satisfied. User will be redirected to another page or authentication provider to satisfy additional authentication challenges.

Question

I have been facing issue while connecting using 'Azure Active Directory - Password'

To use this I have already add my AD account to Sql Server Active Directory Admin. Earlier we are able to connect using AD Admin but Now we are not able to sign in and here is the error message. Also it did not redirect my user .

TITLE: Connect to Server

---

Cannot connect to sqlsvr-idv-sta-dev.database.windows.net.

---

ADDITIONAL INFORMATION:

One or more errors occurred. (mscorlib)

---

One or more errors occurred. (mscorlib)

---

AADSTS50158: External security challenge not satisfied. User will be redirected to another page or authentication provider to satisfy additional authentication challenges.
Trace ID: fc689c89-1b8e-4dc8-8df9-39650cb12e01
Correlation ID: 64348b79-5cdc-4f00-b89f-523652686863
Timestamp: 2021-05-28 13:54:47Z (System.Data)

---

Additional Details:

at ADALNativeWrapper.ADALGetAccessToken(String username, IntPtr password, String stsURL, String servicePrincipalName, ValueType correlationId, String clientId, Boolean* fWindowsIntegrated, Int64& fileTime)
at ADALNativeWrapper.ADALGetAccessToken(String username, String password, String stsURL, String servicePrincipalName, ValueType correlationId, String clientId, Int64& fileTime)
at System.Data.SqlClient.ActiveDirectoryNativeAuthenticationProvider.<>c__DisplayClass2_0.\

Answer 1

If MFA is enabled, disable MFA (multifactor authentication) and try again. Conditional access enabled may be another possible cause, please disable them and try again.

If one of the above solve the issue, then examine your application configuration.

Answer 2

Hey AlbertoMorillo,

Thanks for your Answer and it give me idea that why it failed because earlier we do not have that policy but near to 10 days company just applied on all user account and unfortunately I cannot control that ,is there any other option.