Unable to login without MFA in azure

Question

Hi, I have one invited guest user in Azure AD. Now I want to login to SQL using SSMS. But the problem is it says that microsoft has enables security defaults, because of which it is forcing me to install authenticator app in my mobile.

When I checked in Azure AD properties, the security defaults option was disabled. I want to use SMS OTP method to login to my SQL server which I can't find anywhere.

On the other hand, I have one internal user that I created, with which I can login to my SQL server using OTP method. Can anyone please let me know what can I do disable this forced MFA by microsoft? Please let me know if you need any more details

Answer 1

When you require your account to re-register for MFA and you can't log in to the Portal, you can try navigating to aka.ms/mfasetup to update your authentication method/phone number. Additionally, if you have the correct permissions, you can use the below script to require your User to re-register for MFA.

1.  Connect-MsolService -AzureEnvironment AzureCloud
2.  $User = Get-MSolUser -UserPrincipalName "user@company.onmicrosoft.com"
3.  $ User.StrongAuthenticationMethods
4.  Reset-MsolStrongAuthenticationMethodByUpn -UserPrincipalName "user@company.onmicrosoft.com"

For more info - https://docs.microsoft.com/answers/answers/70361/view.html

If none of the above steps work to reset your account, you'll have to reach out to one of your Authentication Admins or Global Admins within your organization to reset your MFA settings.