Azure Active Directory - Universal with MFA support results in connection error Unable to acquire authorization token (Microsoft.SqlServer.Management.AzureAuthenticationManagement)

Hector 61 Reputation points
2020-10-21T16:43:31.037+00:00

We can connect to SQL server using sql server authentication, but when try to connect with AAD universal with MFA we are receiving the below error.

TITLE: Connect to Server


Cannot connect to server


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 download has failed (the connection was interrupted). (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,259 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,627 questions
{count} votes

Accepted answer
  1. soumi-MSFT 11,776 Reputation points Microsoft Employee
    2020-10-21T17:19:47.413+00:00

    Hello @Hector , thank you for reaching out. This error usually comes up when SQL server fails to trigger MFA using ADAL. it would be great to know which version of SqlServerManagement Studio you are using. Our recommendation is to either use SSMS version 18.6 or above.

    the following link contains the steps that you need to follow while trying to use the Azure AD Universal with MFA option: https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-mfa-ssms-configure#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.

    Hope this helps.

    Do let us know if this helps and if there are any more queries around this, please do let us know so that we can help you further. Also, please do not forget to accept the response as an Answer; if the above response helped in answering your query.


1 additional answer

Sort by: Most helpful
  1. Schmlughtz 1 Reputation point
    2022-01-06T08:17:36.547+00:00

    Hello Guys,

    I am using the up-to-date version of SSMS
    162767-image.png

    However I'm still facing the same authentication issue?

    Any idea of how to solve??

    Thx

    0 comments No comments