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.56k stars 899 forks source link

Incorrect Server Connection #20914

Open gfoley97 opened 1 year ago

gfoley97 commented 1 year ago

Issue Type: Bug

I was noticing a weird issue in our prod SQL environment.

I connected to a SQL server and the bottom right says that i'm connected to our prod server, but it is in fact connected to our dev server (i confirmed this by selecting @@servername).

I cannot use azure data studio if this is going to happen.

Azure Data Studio version: azuredatastudio 1.39.1 (7553f799e175f471b7590302dd65c997b838b29b, 2022-08-30T01:11:13.047Z) OS version: Windows_NT x64 10.0.19044 Restricted Mode: No

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-6820HQ CPU @ 2.70GHz (8 x 2712)| |GPU Status|2d_canvas: enabled
gpu_compositing: enabled
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
rasterization: enabled
skia_renderer: enabled_on
video_decode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled| |Load (avg)|undefined| |Memory (System)|31.82GB (18.04GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (4) Extension|Author (truncated)|Version ---|---|--- agent|Mic|0.49.0 query-history|Mic|0.4.0 azdata-sanddance|msr|4.0.0 sql-search|Red|0.4.1
cheenamalhotra commented 1 year ago

Hi @gfoley97

If this is related to Editing a connection, we've recently made a fix with PR #20907 that should resolve this issue. The fix will be part of next release. Can you confirm the behavior is expected WITHOUT using the 'Edit Connection' context feature?

If you have a reproducible use-case otherwise, please share with us the steps to reproduce the behavior, and we will investigate that as well.

gfoley97 commented 1 year ago

This is not related to edit connection

On Fri, Oct 21, 2022, 5:11 PM Cheena Malhotra @.***> wrote:

Hi @gfoley97 https://github.com/gfoley97

If this is related to Editing a connection, we've recently made a fix with PR #20907 https://github.com/microsoft/azuredatastudio/pull/20907 that should resolve this issue. The fix will be part of next release. Can you confirm the behavior is expected without using the 'Edit Connection' context feature?

— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/20914#issuecomment-1287440384, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOLOYFDAEQOQVBN5A3FZENDWEMBJLANCNFSM6AAAAAARLGVHHA . You are receiving this because you were mentioned.Message ID: @.***>

cssuh commented 1 year ago

@gfoley97 can you please provide us with the steps to reproduce this behavior so we can investigate further?

gfoley97 commented 1 year ago

I've tried but I am unable to recreate this consistently. Very sporadic.

On Wed, Nov 2, 2022, 6:11 PM Christopher Suh @.***> wrote:

@gfoley97 https://github.com/gfoley97 can you please provide us with the steps to reproduce this behavior so we can investigate further?

— Reply to this email directly, view it on GitHub https://github.com/microsoft/azuredatastudio/issues/20914#issuecomment-1301388435, or unsubscribe https://github.com/notifications/unsubscribe-auth/AOLOYFBZJUJQR55V7VVLHP3WGLRH7ANCNFSM6AAAAAARLGVHHA . You are receiving this because you were mentioned.Message ID: @.***>