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

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