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.55k stars 898 forks source link

Add central management server on Mac #17264

Open DBojsen opened 3 years ago

DBojsen commented 3 years ago

Issue Type: Bug

When attempting to add a Central Management Server on Mac, the only authentication options are SQL Server Authentication and Windows Authentocation.

AAD options are missing.

Azure Data Studio version: azuredatastudio 1.32.0 (4a45ba7cf20dd4129f1a08e5e776dfb33e3d1d1e, 2021-08-16T18:09:20.282Z) OS version: Darwin x64 20.6.0

System Info |Item|Value| |---|---| |CPUs|Apple M1 (8 x 24)| |GPU Status|2d_canvas: enabled
gpu_compositing: enabled
metal: disabled_off
multiple_raster_threads: enabled_on
oop_rasterization: enabled
opengl: enabled_on
rasterization: enabled
skia_renderer: disabled_off_ok
video_decode: enabled
webgl: enabled
webgl2: enabled| |Load (avg)|2, 2, 2| |Memory (System)|16.00GB (0.44GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (12) Extension|Author (truncated)|Version ---|---|--- admin-pack|Mic|0.0.2 agent|Mic|0.48.0 cms|Mic|0.8.0 dacpac|Mic|1.8.0 import|Mic|1.3.1 kusto|Mic|0.5.4 profiler|Mic|0.11.0 query-history|Mic|0.1.0 schema-compare|Mic|1.11.0 sql-database-projects|Mic|0.12.0 azdata-sanddance|msr|3.3.0 sql-prompt|Red|0.2.8
kburtram commented 2 years ago

@DBojsen as far as I'm aware CMS is only supported for On-Prem SQL Server instances, which don't support AAD. Am I missing a scenario here? Thanks!

Charles-Gagnon commented 2 years ago

@kburtram It seems like he's referring to the connection to the CMS server itself (which is just a normal SQL connection so can support Integrated/AAD/etc auth)

I'm seeing the same thing so I'm guessing that however the CMS connection widget was made it has its own list of supported auth types or something that wasn't updated with the AAD options.

image

Charles-Gagnon commented 2 years ago

For comparison here's the dialog in SSMS

image

kburtram commented 2 years ago

@Charles-Gagnon is there a scenario where it makes sense to use the AAD options? When I add CMS connection to a Azure SQL DB using AAD in SSMS I get the below error.

image

Charles-Gagnon commented 2 years ago

Good question, @shueybubbles do you know of a scenario where that would actually work?

drdamour commented 6 months ago

@Charles-Gagnon / @kburtram my issue #10872 that got close as a dupe of this is not about adding a CMS s you've suggested here, but adding a new registration within the CMS...it only shows one option windows authentication (which is what i used for my CMS connection if that matters)

if i try to manage an existing one it gives other options like entra.