search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.5k stars 882 forks source link

Connecting to Failover Group does not list databases in Server Tree #4499

Open BroMarduk opened 5 years ago

BroMarduk commented 5 years ago

Issue Type: Bug

When connecting to an Azure failover group, in the servers pane, when expanding the Databases folder in the tree, the "Failed to connect to server xxxxxx".

The databases are available and listed in the main window

Azure Data Studio version: azuredatastudio 1.4.5 (887f4e8985023602e599cf86bdb44df48bb28569, 2019-02-12T06:20:08.633Z) OS version: Windows_NT x64 10.0.17763

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7 CPU 930 @ 2.80GHz (8 x 2807)| |GPU Status|2d_canvas: enabled
checker_imaging: disabled_off
flash_3d: enabled
flash_stage3d: enabled
flash_stage3d_baseline: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
native_gpu_memory_buffers: disabled_software
rasterization: enabled
video_decode: enabled
video_encode: enabled
webgl: enabled
webgl2: enabled| |Memory (System)|23.99GB (12.94GB free)| |Process Argv|C:\Program Files\Azure Data Studio\azuredatastudio.exe| |Screen Reader|no| |VM|0%|
Extensions: none ![Tree](https://user-images.githubusercontent.com/2371774/54385183-6667c600-466c-11e9-8af2-8d5e78482866.png)
BroMarduk commented 5 years ago

FYI, still occurring with 1.5.2

cheenamalhotra commented 1 year ago

Hi @BroMarduk

Could you try setting "MultiSubnetFailover" property to "True"? Related https://github.com/microsoft/azuredatastudio/issues/17901

BroMarduk commented 1 year ago

Thanks @cheenamalhotra but the issue is not related to this as I CAN see the databases in the main pane window on the database tab, they just are not listed in the tree when expanding the Databases folder. I did try the setting on the Advanced connection properties, but no joy.

Seems to be related to the tree view only.