question

VyasManishCapitaSoftware-9511 avatar image
1 Vote"
VyasManishCapitaSoftware-9511 asked VyasManishCapitaSoftware-9511 commented

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

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.<AcquireTokenAsync>b_0()
at System.Threading.Tasks.Task`1.InnerInvoke()
at System.Threading.Tasks.Task.Execute()

azure-active-directoryazure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VyasManishCapitaSoftware-9511 avatar image
0 Votes"
VyasManishCapitaSoftware-9511 answered VyasManishCapitaSoftware-9511 commented

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Probably have to configure the application to work with MFA or conditional access, or disable those features until the applications can be adjusted for those features.

0 Votes 0 ·

Thanks , I will check with application

0 Votes 0 ·