Unable to connect to Azure SQL using SSMS with Universal with MFA option

Rahul Agrawal 1 Reputation point
2021-11-22T22:15:11.72+00:00

I am unable to connect to Azure SQL Server using Active Directory - Universal with MFA option.

The same credential works with Azure Data Studio.
SQL authentication works with SSMS

Also when using MFA option I do get the second login option (2 factor authentication) but fails to connect at end.

TITLE: Connect to Server


Cannot connect to xxxxxxxx.database.windows.net.


ADDITIONAL INFORMATION:

One or more errors occurred. (mscorlib)


One or more errors occurred. (mscorlib)


One or more errors occurred. (mscorlib)


Unable to acquire authorization token (Microsoft.SqlServer.Management.AzureAuthenticationManagement)


One or more errors occurred. (mscorlib)


The browser based authentication dialog failed to complete. Reason: The Internet connection has timed out. (Microsoft.IdentityModel.Clients.ActiveDirectory)


BUTTONS:

OK


SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,328 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
18,743 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CathyJi-MSFT 21,121 Reputation points Microsoft Vendor
    2021-11-23T02:29:24.337+00:00

    Hi @Rahul Agrawal ,

    Which version of your SSMS? Please check this. SSMS > Help > About. In December 2021, releases of SSMS prior to 18.6 will no longer authenticate through Azure Active Directory with MFA. To continue utilizing Azure Active Directory authentication with MFA, you need SSMS 18.6 or later. Recommend you using the latest version SSMS 18.10.

    The following link contains the steps that you need to follow while trying to use the Azure AD Universal with MFA option:

    Connecting by using universal authentication with SSMS

    Do let me know if the steps mentioned there are already followed and still you are getting that error then we can try to dig in further and try to check where the fault lies.

    Make sure the MFA is activated for user that you are using.

    If the issue still not resolved, try below solution that resolved the same issue from other customers.

    Re-registering MFA as below screenshot.

    151575-screenshot-2021-11-23-102608.jpg


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments