Azure Data Studio: adding Entra ID user account fails with "Error: read ECONNRESET"

Martin B 21 Reputation points
2024-05-06T13:50:02.3133333+00:00

Hello,
we are facing the situation in our organization that some users (on specific laptops) have problems to add their personal Entra ID user accounts (formally Azure Active Directory) in Azure Data Studio.

We tried Code Grant authentication as well as Device Code authentication. Both authentication processes in the browser seem to work just fine; the user provides credentials and finally reaches the confirmation page, that the authentication was successful. Next step would be that the user is logged in Azure Data Studio and the account appears in ADS. However, in Azure Data Studio only a very short error message is displayed:

User's image

Error adding account
Error: read ECONNRESET

Some analysis results so far:

  • %appdata%\azuredatastudio\logs does not contain much more detailed error infos:
      [Verbose]: Fetching tenants with uri: https://management.azure.com/tenants?api-version=2019-11-01 - []
      [Error]: Error fetching tenants :Error: read ECONNRESET - []
      [Error]: Login failed: Error: read ECONNRESET - []
    
  • The same user is able to add an account in Azure Storage Explorer on the same laptop → conclusion: firewall settings should be fine; user account seems fine
  • The same user is able to add an account in Azure Data Studio on another laptop → it appears that the issue is related to the settings/installation of ADS. However, settings.json is nearly empty / is the same for both tested installations.
  • There is no proxy enabled for Azure Data Studio. There are no proxy environment variables set.
  • Azure Data Studio 1.48.0 is used (that is the latest version available at the time of this post)
Active Directory
Active Directory
A set of directory-based technologies included in Windows Server.
6,055 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
103 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Martin B 21 Reputation points
    2024-05-13T06:43:20.54+00:00

    It seems, that this issue is due to networking in our organization (routing, firewall, proxy).
    Workaround for us is to specify a proxy when adding the Entra ID user account and then removing it, before connecting to databases.