Authentication failure AAD

[adsbot[bot]]

Given I have 2 Azure Active directories:

• mycompany.onmicrosoft.com - domain verified as "mycompany.org.au"
• myazurehosting.onmicrosoft.com

I have a user account "me" in the directory "mycompany.onmicrosoft.com", my user name is "me!mycompany.org.au"

"me!mycompany.org.au" is also an external "member" user in the directory "myazurehosting.onmicrosoft.com"

I have a number of Azure SQL instances in subscriptions associated with the "myazurehosting.onmicrosoft.com" tenant.

When I try to create a new connection to an Azure SQL Server I:

• Enter my-servername.database.windows.net
• Authentication type - Azure Active Directory - Universal with MFA support
• Account - Select "Add Account" and follow the process to sign
• Azure AD Tenant - "myazurehosting.onmicrosoft.com"
• Database - "mydatabase"

When I press connect the error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' is shown

I have tried '' and 'master' as the database and get the same error.

The connection can be made without issue with SQL Server Management Studio

[adstestbot[bot]]

Thanks for submitting this issue. Please also check if it is already covered by an existing one, like:

• Unable to specify AAD login under Account tab with AAD-Universal with MFA Support Authentication type (#4666)