BapsDBC
New Contributor III

Exactly same problem for me. It was working alright a two weeks ago. Since last week I have having the problem. Confirmed from colleagues that this is not a regional problem. It is happening all over.

Can somebody please help ?

dustinvannoy
Contributor

I have steps that should help many with this issue get connected again. I hit this on my personal Azure pay-as-you-go account where I now have to login as a different username to get to my Databricks Account.

  • In Azure Portal, go to Azure Entra ID resource and see which users exist. For me the admin user I normally log in with doesn't show exactly, instead a similar username with #ext# in it shows up.
  • If there is an #ext# user that is similar to what you log in as, go to portal.azure.com on a fresh browser session (such as incognito browsing) and try logging in with that full username (should include #ext#).
  • You may need to reset password to get logged in as this user.
  • After you get that working, go to Databricks Account login at accounts.azuredatabricks.net and login with the #EXT# email.

See images below of how my typical username which I logged in with to Databricks (training@dustinvannoy.com) is no longer showing up in Microsoft Entra ID, but I now have the #ext# user (training_dustinvannoy.com#EXT#@trainingdustinvannoy.onmicrosoft.com) which has those important Azure admin permissions and I can use to login to accounts.azuredatabricks.net.

dustinvannoy_0-1724172188792.png

dustinvannoy_2-1724172375576.png

 

View solution in original post

Thanks Dustin, I have tried your solution and I can indeed use the account console when I logon with my #EXT# user. Microsoft contacted me today for some extra info, so I will also pass this information to them.

Regards Marco

Hi @dustinvannoy, Thanks for this. I have tried this solution and it worked perfectly fine. Microsoft also, provided me with another solution which requires us to create a separate external user and assign the 'Global Administrator' role, which also worked.

For anyone who is interested please see the document here which details the steps required to implement both approaches. 

https://github.com/cloudboxacademy/azure_databricks_course/blob/main/known-issues/unable-to-login-to...

Thanks

View solution in original post

The second option has worked for me. Thanks @RameshRetnasamy   for the insightful guide..👏

works perfectly, spent some time wondering if this has to do with 'Transition from Azure classic administrator roles to RBAC roles', however looks like root cause is something else & this solution is fantastic , thank you for sharing 🙂

murthypatnaik
New Contributor II

Hi @RameshRetnasamy @dustinvannoy 

I am facing this issue suddenly (uswest-2), and not seeing account console. I tried to login with #EXT# user and reset the password; but still not seeing the console. any input?

Hi @murthypatnaik, There are 2 approaches you can follow to get around this issue. Please see my reply above with a link to the documentation on github. The link gives you the step-by-step solution with screenshots to both approaches. Hope this helps!

Thank you @RameshRetnasamy 2nd option worked for me. 

dataeng42io
New Contributor III

Thanks @dustinvannoy 

your solution worked for me. 

I had posted my issue in another post I will refer to this article if anyone is having the same issue.

Cheers

PJ

 

champrats
New Contributor II

Thanks, @dustinvannoy and @RameshRetnasamy!

When I first started the Formula1 training course and couldn’t find the Account Console, I assumed Databricks must have changed something. Thanks for clarifying—I’m now able to follow along with the instructions. I'd also like to give credit to this YouTube channel: https://www.youtube.com/watch?v=pxmJooGBOyI

When logging in for the first time as an ‘external user created by Azure’ (aka #ext# user), you’ll need to reset your password. It also offers optional setup for Microsoft Authenticator. You have 14 days to complete this, so it’s a good idea to set it up for added security on your #ext# user account.

satyaki_guha
New Contributor II

Hi @RameshRetnasamy thanks for your solution.I was able to login to Databricks Account Console but was unable to set the metastore path.Something got broke along the way.It would definitely be beneficial if we could have the same email address for out azure account as well as databricks admin.When I change it to the external one/create a new one I can access the page , but is not able to set the container.Hope somebody fixes it

mits1
New Contributor III

Thanks Dustin.

This solves my issue too,but I want to know WHY this happened?

I used an email id (say,xx@gmail.com) to login to Azure,using the same id/user I have deployed databricks and able to launch the workspace.But not account console.what's so special with account console?Why it did not allow the user to login with same id but with #EXT# user only?

Does that also mean that everytime I login to Azure porta; using #ext# user only and not with xx@gmail.com??