question

ChadBentz-3830 avatar image
1 Vote"
ChadBentz-3830 asked GeethaThatipatri-MSFT edited

Cross-tenant access settings for external collaboration (preview) - "Trust multi-factor authentication from Azure AD tenants" setting causing sign in loops and failure for SQL Server Management Studio

Enabled this [cross-tenant access settings for external collaboration (preview) - "Trust multi-factor authentication from Azure AD tenants"][1] preview feature to allow our multi AAD environment utilizing B2B Guests in our Resource tenant to login with our Home AAD tenant. (can provide more details here privately) During sign on flow - SOME users can reproduce a scenario where they get redirected to the HOME AAD 7+ times in a loop and eventually are presented with : "We couldn't sign you in. Please try again." IDP logs tied to home AAD tenant show valid sign-in events. AAD logs in our resources tenant (b2b guest users live here) sporadically showed Auth Failure with "Authenitcation Requirement" marked as "Single-factor Authentication" - other users no logs hit the resource tenant. - Application Azure SQL Database and Data Warehouse - Sign-in error code 50089 - Failure reason Authentication failed due to flow token expired. - Additional Details Expected - auth codes, refresh tokens, and sessions expire over time or are revoked by the user or an admin. The app will request a new login from the user. This is most easily reproduced in Sql Server Management Studio ( v18.10) when selecting Authentication: "Azure Active Directory - Universal with MFA" .. This will trigger the IE7 WebPop to AAD (without a tenant passed in) ![174939-image.png][2] ![175091-image.png][3] [1]: https://techcommunity.microsoft.com/t5/azure-active-directory-identity/collaborate-more-securely-with-new-cross-tenant-access-settings/ba-p/2147077 [2]: /answers/storage/attachments/174939-image.png [3]: /answers/storage/attachments/175091-image.png

azure-ad-multi-factor-authenticationazure-ad-b2b
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I had same users install the AzureAD module in powershell as it uses a very similar WebPop via IE7 (win 10 ) ... but that worked, they had no issues authenticating - notable difference is we usually pass the tenant of our guest AAD to that command so if there is some AAD->AAD crazyness going on with HRD - then it wont reproduce it.

Also we just discovered these same users can reproduce in the browser going to myaccount.microsoft.com and choosing Security Info

0 Votes 0 ·

Hi anonymous user - we'd like to get some additional information on this issue. Would it be possible to please message me directly: sranjit@microsoft.com

Looking forward to resolving this issue!

Thank you,
Sangeeta

1 Vote 1 ·

0 Answers