search

Azure / azure-cosmosdb-ads-extension

Azure Data Studio extension for Azure CosmosDB
MIT License
16 stars 10 forks source link

Connection Failure to Mongo account #85

Closed cheenamalhotra closed 9 months ago

cheenamalhotra commented 1 year ago

Originally reported: https://github.com/microsoft/azuredatastudio/issues/23146#issue-1711726280

By @sailorjack Issue Type: Bug

I tried to connect my Azure Cosmos DB (Mongo DB) following the instructions in https://learn.microsoft.com/de-de/sql/azure-data-studio/quickstart-azure-cosmos-db-mongodb?view=sql-server-ver16. I got an connection error with the following message: "Failed to connect: getaddrinfo ENOTFOUND eta-db-2.mongo.cosmos.azure.com" Same issue occurred while using the connection string instead.

Azure Data Studio version: azuredatastudio 1.43.0 (b790d700898b1095d83e62f0de14678a58222520, 2023-04-10T23:14:27.236Z) OS version: Windows_NT x64 10.0.19045 Restricted Mode: No Preview Features: Enabled

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i5-8350U CPU @ 1.70GHz (8 x 1896)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
skia_renderer: enabled_on
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: disabled_off| |Load (avg)|undefined| |Memory (System)|15.84GB (6.38GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (9) Extension|Author (truncated)|Version ---|---|--- admin-tool-ext-win|Mic|0.1.2 azcli|Mic|1.8.0 azure-cosmosdb-ads-extension|Mic|0.3.3 azuredatastudio-oracle|Mic|0.1.2 dsct-oracle-to-ms-sql|Mic|0.4.1 net-6-runtime|Mic|1.1.0 schema-compare|Mic|1.18.0 sql-database-projects|Mic|1.0.1 mongodb-vscode|mon|0.9.3

Moving issue here as it applies to Mongo DB extension.

sailorjack commented 1 year ago

pinging the DB is not working due to host resolution behind our companies proxy. I can pass the proxy on higher OSI layers, but since ping is operating on quite low levels it is not working.

languy commented 1 year ago

I am able to ping it and resolve the DNS address, so your account is most likely up and running. The original error seems to indicate that the mongo client isn't able to resolve the hostname.

Are you able to perform nslookup eta-db-2.mongo.cosmos.azure.com?

languy commented 9 months ago

Closing stale issue. If the issue remains, please contact support through the Azure portal in your resource page.