Can't connect via MFA after update to 1.17.0

[SteveDMurphy]

Issue Type: Bug

Updated to new version today (1.17.0) and can no longer connect to azure data warehouse with MFA. Have removed existing accounts, etc. and still same error. NT AUTHORITY\ANONYMOUS LOGON

Azure Data Studio version: azuredatastudio 1.17.0 (b32a48a, 2020-04-24T00:06:48.375Z)
OS version: Darwin x64 19.4.0

System Info

Item	Value
CPUs	Intel(R) Core(TM) i7-8557U CPU @ 1.70GHz (8 x 1700)
GPU Status	2d_canvas: enabled flash_3d: enabled flash_stage3d: enabled flash_stage3d_baseline: enabled gpu_compositing: enabled metal: disabled_off multiple_raster_threads: enabled_on oop_rasterization: disabled_off protected_video_decode: unavailable_off rasterization: enabled skia_renderer: disabled_off_ok video_decode: enabled viz_display_compositor: enabled_on viz_hit_test_surface_layer: disabled_off_ok webgl: enabled webgl2: enabled
Load (avg)	2, 2, 2
Memory (System)	16.00GB (6.47GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions: none

[Charles-Gagnon]

@aaomidi

[adsbot]

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.

To find your logs:

• Open command palette (Click View -> Command Palette)
• Run the command: Developer: Open Logs Folder

This will open the log file locally. Please include renderer.log

[SteveDMurphy]

This is what I was able to get out of the renderer.log just now (removed connection info)

[2020-04-28 16:35:45.398] [renderer1] [info] Creating new connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|
[2020-04-28 16:35:45.398] [renderer1] [info] Adding connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|
[2020-04-28 16:35:45.399] [renderer1] [info] Successfully added connection connection:providerName:MSSQL|applicationName:azdata|
[2020-04-28 16:35:46.929] [renderer1] [info] Deleting connection connection:providerName:MSSQL|applicationName:azdata|
[2020-04-28 16:35:46.944] [renderer1] [error] Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
[2020-04-28 16:39:22.488] [renderer1] [error] An unknown error occurred. Please consult the log for more details.
[2020-04-28 16:39:43.909] [renderer1] [error] No application in the Launch Services database matches the input criteria.: Error: No application in the Launch Services database matches the input criteria.

[aaomidi]

To confirm, were you able to connect to this server with azure authentication before? Does authenticating with SqlLogin work?

[SteveDMurphy]

Thanks for the quick response @aaomidi - yes was able to connect just a couple of hours ago. A teammate was having issues connecting after the update and confirmed that I ran into the same issue after I did the update. Also yes - sqllogin does work

[jtandrew]

I am having the exact same issue on my Mac and on a Windows machine.
Here is my information. I was able to connect using this method earlier today. I have the same issue with the Insiders Build

[2020-04-28 13:43:23.602] [renderer1] [error] Cannot read property 'path' of undefined: TypeError: Cannot read property 'path' of undefined at Object.t.isAbsolutePath (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:513:215) at e.withProvider (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:2178:95) at e.doResolveFile (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:2179:487) at e.resolve (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:2179:212) at t.createListEntries (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:6058:915) at t.mapListEntries (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:6060:150) at r (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:6054:333) at file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:6054:360 at ZoneDelegate.invoke (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:388:26) at Zone.run (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:138:43) at /Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:872:34 at ZoneDelegate.invokeTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:421:31) at Zone.runTask (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:188:47) at drainMicroTaskQueue (/Applications/Azure Data Studio.app/Contents/Resources/app/node_modules.asar/zone.js/dist/zone-node.js:595:35) [2020-04-28 13:43:41.053] [renderer1] [info] Creating new connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:|server:xxxxxx.database.windows.net|user:first.lastname@company.com|group:C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx [2020-04-28 13:43:41.053] [renderer1] [info] Adding connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:|server:xxxxxx.database.windows.net|user:first.lastname@company.com|group:C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx [2020-04-28 13:43:41.054] [renderer1] [info] Successfully added connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:|server:xxxxxx.database.windows.net|user:first.lastname@company.com|group:C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx [2020-04-28 13:43:43.466] [renderer1] [info] Adding connection with DB name connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:master|server:xxxxxx.database.windows.net|user:first.lastname@company.com|group:C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx [2020-04-28 13:44:02.758] [renderer1] [warning] Cannot find node status for session: xxxxxx.database.windows.net_master_first.lastname@company.com_AzureMFA_C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx and node path: xxxxxx.database.windows.net/Databases/DatabaseName [2020-04-28 13:44:02.797] [renderer1] [info] Deleting connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:master|server:xxxxxx.database.windows.net|user:first.lastname@company.com|group:C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx [2020-04-28 13:44:02.797] [renderer1] [info] Deleting connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:master|server:xxxxxx.database.windows.net|user:first.lastname@company.com|group:C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx [2020-04-28 13:44:02.798] [renderer1] [info] Removing connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:master|server:xxxxxx.database.windows.net|user:first.lastname@company.com|group:C777F06B-202E-4480-B475-xxxxxxxxxxxxxxx [2020-04-28 13:44:20.556] [renderer1] [error] Error: Failed to get Azure account token for connection at e.connectWithOptions (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5647:607) [<root>] at async e.handleDefaultOnConnect (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7815:137) [<root>] at async file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7813:205 [<root>] [2020-04-28 13:44:25.539] [renderer1] [error] Error: Failed to get Azure account token for connection at e.connectWithOptions (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:5647:607) [<root>] at async e.handleDefaultOnConnect (file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7815:137) [<root>] at async file:///Applications/Azure Data Studio.app/Contents/Resources/app/out/vs/workbench/workbench.desktop.main.js:7813:205 [<root>] [2020-04-28 13:44:44.329] [renderer1] [info] Creating new connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:DatabaseName|server:xxxxxx.database.windows.net|user:first.lastname@company.com|databaseDisplayName:DatabaseName|group:428d2aaa-b0f1-4d78-95cf-xxxxxxxxxxxxxxx [2020-04-28 13:44:44.329] [renderer1] [info] Adding connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:DatabaseName|server:xxxxxx.database.windows.net|user:first.lastname@company.com|databaseDisplayName:DatabaseName|group:428d2aaa-b0f1-4d78-95cf-xxxxxxxxxxxxxxx [2020-04-28 13:44:44.329] [renderer1] [info] Successfully added connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:DatabaseName|server:xxxxxx.database.windows.net|user:first.lastname@company.com|databaseDisplayName:DatabaseName|group:428d2aaa-b0f1-4d78-95cf-xxxxxxxxxxxxxxx [2020-04-28 13:44:44.601] [renderer1] [info] Deleting connection connection:providerName:MSSQL|applicationName:azdata|authenticationType:AzureMFA|database:DatabaseName|server:xxxxxx.database.windows.net|user:first.lastname@company.com|databaseDisplayName:DatabaseName|group:428d2aaa-b0f1-4d78-95cf-xxxxxxxxxxxxxxx [2020-04-28 13:44:44.621] [renderer1] [error] Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

[SteveDMurphy]

Interesting twist as well, noticed that the MFA connection works when connecting to a separate sql database but not a data warehouse