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.58k stars 904 forks source link

Agent doesn't show on dashboard for user db connections #16794

Open scottkolle opened 3 years ago

scottkolle commented 3 years ago

Issue Type: Bug

sql agent extension though installed does not appear on "manage:" home tried reinstallign azure data studio and uninstalling and reinstalling the agent extension.

Azure Data Studio version: azuredatastudio 1.31.1 (65fb22cc7c36db9c53af1ed2fdbdf48f66c682be, 2021-07-28T21:03:21.018Z) OS version: Windows_NT x64 10.0.19043

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i9-9880H CPU @ 2.30GHz (16 x 2304)| |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)|63.88GB (54.09GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (5) Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 agent|Mic|0.48.0 dacpac|Mic|1.8.0 import|Mic|1.3.1 profiler|Mic|0.11.0
kburtram commented 3 years ago

@scottkolle could you please confirm that "Preview Features" are enabled in the User Settings? SQL Agent support is still in preview and will only display when that setting is true.

scottkolle commented 3 years ago

I searched the settings in the Azure Data Studio UI and the settings file show it is open too "workbench.enablePreviewFeatures": true, "datasource.connectionGroups": [ { The extension doesn’t’ show @. Shows it is installed… tried rebooting, uninstalling/reinstalling the extensions and the Azure Data Studio From: Karl Burtram @.> Sent: Monday, August 16, 2021 3:56 PM To: microsoft/azuredatastudio @.> Cc: Scott K. Olle @.>; Mention @.***> Subject: Re: [microsoft/azuredatastudio] sql agent extension though installed does not appear on "manage:" home (#16794)

@scottkollehttps://github.com/scottkolle could you please confirm that "Preview Features" are enabled in the User Settings? SQL Agent support is still in preview and will only display when that setting is true.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/16794#issuecomment-899843735, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEODEGORDAC3NLIUMXDXNQLT5GCQTANCNFSM5CISAOTA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email.

github-actions[bot] commented 3 years ago

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster.

There are two types of logs to collect:

Console Logs

Application Logs

scottkolle commented 3 years ago

I tried to access the SQL Server Agent by going to Home on the server before I gathered these logs. Attached are the logs. Thank you, Scott

From: github-actions[bot] @.> Sent: Wednesday, August 18, 2021 6:58 PM To: microsoft/azuredatastudio @.> Cc: Scott K. Olle @.>; Mention @.> Subject: Re: [microsoft/azuredatastudio] sql agent extension though installed does not appear on "manage:" home (#16794)

We need more info to debug your particular issue. If you could attach your logs to the issue (ensure no private data is in them), it would help us fix the issue much faster.

There are two types of logs to collect:

Console Logs

Application Logs

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/16794#issuecomment-901527552, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEODEGLRIRSEB34IWAWQ7WTT5RJIDANCNFSM5CISAOTA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email.

Charles-Gagnon commented 3 years ago

@scottkolle You need to attach the files through the Github UI - they don't support attachments through e-mail replies.

scottkolle commented 3 years ago

attached are the files -Removed files as they are no longer needed-

Charles-Gagnon commented 3 years ago

It looks like your connecting directly to a DB - Agent is currently configured to only show for connections to master (or default). If you make a new connection with those does it show up then?

scottkolle commented 3 years ago

Yes, that fixed it I see it now. I didn’t think about it needing to point to master. That resolves this. Thank you, Scott

From: Charles Gagnon @.> Sent: Thursday, August 19, 2021 10:18 AM To: microsoft/azuredatastudio @.> Cc: Scott K. Olle @.>; Mention @.> Subject: Re: [microsoft/azuredatastudio] sql agent extension though installed does not appear on "manage:" home (#16794)

It looks like your connecting directly to a DB - Agent is currently configured to only show for connections to master (or default). If you make a new connection with those does it show up then?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/16794#issuecomment-902048146, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEODEGJP25OVVD6I3WWZL7TT5UVDRANCNFSM5CISAOTA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email.

Charles-Gagnon commented 3 years ago

@kburtram @abist Something to consider for improvement here - it would be great if the Agent stuff showed up even when connecting to a user DB as long as that user has access to the agent objects. SSMS appears to be doing this.

scottkolle commented 3 years ago

That was a little confusing, but makes since that it is on only when you are set to master, but yes a little confusing.

From: Charles Gagnon @.> Sent: Thursday, August 19, 2021 10:30 AM To: microsoft/azuredatastudio @.> Cc: Scott K. Olle @.>; Mention @.> Subject: Re: [microsoft/azuredatastudio] sql agent extension though installed does not appear on "manage:" home (#16794)

@kburtramhttps://github.com/kburtram @abisthttps://github.com/abist Something to consider for improvement here - it would be great if the Agent stuff showed up even when connecting to a user DB as long as that user has access to the agent objects. SSMS appears to be doing this.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/16794#issuecomment-902057915, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AEODEGL5337OR5H4OZX4GKTT5UWPTANCNFSM5CISAOTA. Triage notifications on the go with GitHub Mobile for iOShttps://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Androidhttps://play.google.com/store/apps/details?id=com.github.android&utm_campaign=notification-email.