Skip to main content

Notifications

Announcements

No record found.

CDS SQL Connection Error AADSTS50076 Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access

Dilip Profile Picture Dilip 1,164
Dear Friends,

Just a quick post on this error, I got while trying to connect to our CDS database using SQL Management Studio

Error:

AADSTS50076: Due to a configuration change made by your administrator, or because you moved to a new location, you must use multi-factor authentication to access






Fix:

Since MFA authentication was turned ON:

To overcome, this error, I had to login with the authentication method: Azure Active Directory - Universal with MFA



You can read more about the MFA policies here - https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-configure

Comments

*This post is locked for comments