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.52k stars 894 forks source link

"Invalid Kusto connection scheme" when trying to connect to ADX cluster #25434

Open garrynewman opened 5 months ago

garrynewman commented 5 months ago

Type: Bug

I have two ADX clusters on my account, one connects fine but the other doesn't. They have the same permissions etc.

The only real difference, which is a long shot, is that the one that won't connect has a - character in it.

[0]Kusto.Cloud.Platform.Utils.UtilsArgumentException: Invalid Kusto connection scheme: '' when using API 'Query'
Timestamp=2024-02-28T09:13:45.8544604Z
MachineName=GARRYPC2023
ProcessName=MicrosoftKustoServiceLayer
ProcessId=70292
ThreadId=27440
AppDomainName=MicrosoftKustoServiceLayer
ActivityStack=(Empty activity stack)
MethodName=
ArgumentName=
Details=

   at Kusto.Data.Net.Client.KustoClientFactory.CreateCslQueryProvider(KustoConnectionStringBuilder builder)
   at Microsoft.Kusto.ServiceLayer.DataSource.Kusto.KustoClient.Initialize(DataSourceConnectionDetails connectionDetails) in D:\a\1\s\src\Microsoft.Kusto.ServiceLayer\DataSource\Kusto\KustoClient.cs:line 44
   at Microsoft.Kusto.ServiceLayer.DataSource.Kusto.KustoClient..ctor(DataSourceConnectionDetails connectionDetails, String ownerUri) in D:\a\1\s\src\Microsoft.Kusto.ServiceLayer\DataSource\Kusto\KustoClient.cs:line 38
   at Microsoft.Kusto.ServiceLayer.DataSource.DataSourceFactory.Create(ConnectionDetails connectionDetails, String ownerUri) in D:\a\1\s\src\Microsoft.Kusto.ServiceLayer\DataSource\DataSourceFactory.cs:line 36
   at Microsoft.Kusto.ServiceLayer.Connection.ReliableDataSourceConnection..ctor(ConnectionDetails connectionDetails, RetryPolicy connectionRetryPolicy, RetryPolicy commandRetryPolicy, IDataSourceFactory dataSourceFactory, String ownerUri) in D:\a\1\s\src\Microsoft.Kusto.ServiceLayer\DataSource\ReliableDataSourceConnection.cs:line 65
   at Microsoft.Kusto.ServiceLayer.Connection.DataSourceConnectionFactory.CreateDataSourceConnection(ConnectionDetails connectionDetails, String ownerUri) in D:\a\1\s\src\Microsoft.Kusto.ServiceLayer\Connection\DataSourceConnectionFactory.cs:line 36
   at Microsoft.Kusto.ServiceLayer.Connection.ConnectionService.TryOpenConnection(ConnectionInfo connectionInfo, ConnectParams connectionParams) in D:\a\1\s\src\Microsoft.Kusto.ServiceLayer\Connection\ConnectionService.cs:line 402

Extension version: 0.5.8 Azure Data Studio version: azuredatastudio 1.47.1 (b6f7beb01f92adaa4b79b6b6f3ac704e95cafe6e, 2024-01-10T02:15:02.628Z) OS version: Windows_NT x64 10.0.22631 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i9-14900K (32 x 3187)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|63.83GB (39.84GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
madiele commented 1 month ago

I had the same error when connecting using the browse tab and looking for the server in azure it seems the problem is with the fact that it will populate the server field like this:

??????.westeurope.kusto.windows.net

but it should actually be like this

https://??????.westeurope.kusto.windows.net

by manually fixing the server field the issue goes away