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.
Azure Data Studio: adding Entra ID user account fails with "Error: read ECONNRESET"
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:
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)
1 answer
Sort by: Most helpful
-
Martin B 121 Reputation points
2024-05-13T06:43:20.54+00:00