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.
My organisation has many Azure tenants, all staff user accounts are in the primary tenant then guested into the various additional tenants where our Azure resources reside.
Conditional access policies applied to the primary tenant limiting signing in to devices within the corporate network. Our development workstations are in a sandboxed enviornment outside the corporate network.
I am attempting to use Azure Data Studio to connect to an Azure SQL Database instance that is associated with one of our organisations additional tenants. This is a simple process using SQL Server Management studio.
Using Azure data studio I:
Select the "Accounts" Extension button on the bottom left of the main app window.
Press the + button on the "Linked accounts" window that shows
When the Microsoft login screen shows, I select "Use another account"
Select, "Sign in options" then "Sign in to an organization"
Enter the domain of the tenant prevlnw.onmicrosoft.com
Complete the sign in process
Now, I try to create a connection to my Azure SQL Database by navigating to the "Connections" blade
Press "New Connection"
When filling in the "Connection Details" I choose input type of "Parameters"
Enter the server name e.g. my-server-name.database.windows.net
Authentication type "Microsoft Entre ID - Universal with MFA support"
Account - I select the account registered earlier
I am then shown a popup message saying "Your Tenant {guid} requires you to re-authenticate again to access https://database.windows.net/ resources: Press Open to start the authentication process"
If I select the account I just signed in with, sign in fails with the error "Your sign-in was successful, but does not meet the criteria to access this resource. For example, you might be signing in from a browser, app or location that is restricted by your admin."
If I try this again but select "Use another account", then "Sign in-options" the "Sign in to an organization" option is not shown. So I proceed by entering my credentials again and and am still presented with the same conditional access error.
NOTE: I have successfully connected to the Azure SQL Database using VS Code and the SQL Server Extension. The process of having to select the organisation every time I sign is however quite frustrating.
Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 2024-02-27T00:05:08.293Z)
OS version: Windows_NT x64 10.0.22621
Restricted Mode: No
Preview Features: Enabled
Modes:
Type: Bug
My organisation has many Azure tenants, all staff user accounts are in the primary tenant then guested into the various additional tenants where our Azure resources reside.
Conditional access policies applied to the primary tenant limiting signing in to devices within the corporate network. Our development workstations are in a sandboxed enviornment outside the corporate network.
I am attempting to use Azure Data Studio to connect to an Azure SQL Database instance that is associated with one of our organisations additional tenants. This is a simple process using SQL Server Management studio.
Using Azure data studio I:
Select the "Accounts" Extension button on the bottom left of the main app window.
Press the + button on the "Linked accounts" window that shows
When the Microsoft login screen shows, I select "Use another account"
Select, "Sign in options" then "Sign in to an organization"
Enter the domain of the tenant prevlnw.onmicrosoft.com
Complete the sign in process
Now, I try to create a connection to my Azure SQL Database by navigating to the "Connections" blade
Press "New Connection"
When filling in the "Connection Details" I choose input type of "Parameters"
Enter the server name e.g. my-server-name.database.windows.net
Authentication type "Microsoft Entre ID - Universal with MFA support"
Account - I select the account registered earlier
I am then shown a popup message saying "Your Tenant {guid} requires you to re-authenticate again to access https://database.windows.net/ resources: Press Open to start the authentication process"
NOTE: I have successfully connected to the Azure SQL Database using VS Code and the SQL Server Extension. The process of having to select the organisation every time I sign is however quite frustrating.
Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 2024-02-27T00:05:08.293Z) OS version: Windows_NT x64 10.0.22621 Restricted Mode: No Preview Features: Enabled Modes:
System Info
|Item|Value| |---|---| |CPUs|AMD EPYC 7763 64-Core Processor (8 x 2445)| |GPU Status|2d_canvas: unavailable_softwarecanvas_oop_rasterization: disabled_off
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: disabled_software
multiple_raster_threads: enabled_on
opengl: disabled_off
rasterization: disabled_software
raw_draw: disabled_off_ok
video_decode: disabled_software
video_encode: disabled_software
vulkan: disabled_off
webgl: unavailable_software
webgl2: unavailable_software
webgpu: unavailable_software| |Load (avg)|undefined| |Memory (System)|31.95GB (19.39GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (2)
Extension|Author (truncated)|Version ---|---|--- schema-compare|Mic|1.21.0 sql-database-projects|Mic|1.4.2