Azure ActiveDirectory interactive stopped working

Avatar
David Sartoris
Created

I'm trying to login to an Azure SQL DB via AAD with MFA (required by company policy). I was not having any issue with this last Friday. Today, DataGrip opens the browser and it looks like it's trying to connect to login.microsoft.com but switches to a localhost url with a random port number instead of the Microsoft login url. The browser opens several tabs doing the same thing.

Eventually, I get an error in DataGrip: 

Failed to authenticate the user david.sartoris@loyalhealth.com in Active Directory (Authentication=ActiveDirectoryInteractive). No Authorization code was returned from the server

 

I updated to the latest DataGrip version and still have the problem. 

 

I do not use proxies. I do not have this problem using Azure Data Studio.

 

This seems similar to https://intellij-support.jetbrains.com/hc/en-us/community/posts/4410609501074-Authentication-via-Azure-Active-Directory-Interactive-does-not-work?input_string=Azure%20ActiveDirectory%20interactive%20stopped%20working

Any ideas what the problem could be?

Votes

0

Share

2 comments
Avatar
Arina Efremova
Created

Hi David,

The issue is probably related to the recent Chrome update. It was also reported to YouTrack as DBE-20291.

Solutions:

  • Check HSTS settings in your browser as mentioned in this comment
  • Open Chrome with the following --disable-features flag as mentioned here:
open -a "Google Chrome" --args --disable-features=PrivateNetworkAccessForNavigations,PrivateNetworkAccessForNavigationsWarningOnly
1
Avatar
David Sartoris
Created

Arina Efremova  I set the Safari browser as default and it worked! I'd rather use Brave (Chromium based) so I'll try again periodically to see if it gets fixed.

Thanks for your input!

0

Please sign in to leave a comment.