Azure SQL: No Authorization code was returned from the server

[Aileron79]

Description

I have been using dbeaver with Azure SQL quite a while, the day before yesterday it stopped working with this error message when trying to connect with my Active Directory user:

In the browser window which usually says "Authentication complete, you can now close this window" I just get this:

Edit:
The issue appeared simultaneously on multiple machines. Note that I also tried older versions, back to 23.3.0, the issue persists. Also, these versions used to work. My assumption is that maybe MS changed something in their authentication flow. which is not captured by the driver.

My default browser is Chrome which usually is opened by dbeaver. I also tried to use the internal browser for authentication, but with that one I always ended up in an authorization loop, this has not changed.

Edit 2:
Seems to be Chrome-related since it works flawlessly when setting my default browser to Edge. Still, dbeaver will open the default browser even though I selected Microsoft Edge in the preferences.

DBeaver Version

24.0.0

Operating System

Windows 10 and 11

Database and driver

Azure SQL, Microsoft JDBC Driver for SQL Server

Steps to reproduce

Try to connect to an Azure SQL database not using database credentials but Azure identities as recommended by MS.

Additional context

I am tunnelling the connection through Azure VPN but that should not have any impact whatsoever.

[Destrolaric]

Hi,
Could you please send me the log files? You can find instructions here: https://dbeaver.com/docs/wiki/Log-files/. Thank you.

[Viittis]

FYI, I can confirm the same issue. Similar issue is also repeated with SQL Server Management Studio 19 (I'm not using the latest version), so it suggests that perhaps a Chrome updated causes this issue.

Using dbeaver I can't connect at all, it just opens multiple new tabs on Chrome. Using SSMS19 I get access but the page is left open with an error message.

Hope info this helps with the issue

[Destrolaric]

@Viittis Hi, JDBC driver has buggy behavior when it creates multiple pages of OAuth during retry attempts. So something else is probably leading to being unable to connect. microsoft/mssql-jdbc#2237
Logs, might help.
Could you please send me the log files? You can find instructions here: https://dbeaver.com/docs/wiki/Log-files/. Thank you.

[Viittis]

This works for me now, with both Dbeaver and SSMS19. I guess it was MS after all as I didnt update chrome in the last few hours.

[E1izabeth]

@Aileron79 is this issue still actual for you?

[E1izabeth]

It's been a while since no update here. If the issue is still actual please let me know and provide additional information.