Can't access teamstelemetry01.eastus2.kusto.windows.net

[johnw42]

I'm trying to connect to teamstelemetry01.eastus2.kusto.windows.net using my Microsoft Entra ID as [email protected]. I am able to connect and run queries using Kusto.Explorer and dataexplorer.azure.com.

It seems to connect to server, but it can't access any databases. The progress indicator for the server has a green dot but the spinner never goes away:

I see this error in the "SQL Tools Service" output:

[Error - 5:50:39 PM] Request admin/getdatabaseinfo failed.
  Message: System.AggregateException: One or more errors occurred. (An exception occurred while executing a Transact-SQL statement or batch.)
 ---> Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch.
 ---> Microsoft.Data.SqlClient.SqlException (0x80131904): Request is invalid and cannot be processed: Semantic error: OTR0001: Sql node of type 'Microsoft.SqlServer.TransactSql.ScriptDom.BeginEndBlockStatement' is not implemented [line:position=4:9]
RequestId: TDS;0aa3599f-c880-4eef-85b4-836de0ac6e4d;4
Time: 2025-01-28T01:50:38.8640321Z
   at Microsoft.SqlServer.Management.Common.ConnectionManager.ExecuteTSql(ExecuteTSqlAction action, Object execObject, DataSet fillDataSet, Boolean catchException)
   at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
ClientConnectionId:0aa3599f-c880-4eef-85b4-836de0ac6e4d
Error Number:40000,State:1,Class:16
   --- End of inner exception stack trace ---
   at Microsoft.SqlServer.Management.Common.ServerConnection.GetExecuteReader(SqlCommand command)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand, SqlCommand& command)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query, SqlCommand& command)
   at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)
   at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)
   at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)
   at Microsoft.SqlServer.Management.Smo.DatabaseLevel.GetData(EnumResult res)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData()
   at Microsoft.SqlServer.Management.Sdk.Sfc.Environment.GetData(Request req, Object ci)
   at Microsoft.SqlServer.Management.Sdk.Sfc.Enumerator.GetData(Object connectionInfo, Request request)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.GetEnumeratorDataReader(Request req)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.GetInitDataReader(String[] fields, OrderBy[] orderby)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ImplInitialize(String[] fields, OrderBy[] orderby)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize(Boolean allProperties)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.Initialize()
   at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.InitializeChildObject(ObjectKeyBase key)
   at Microsoft.SqlServer.Management.Smo.SmoCollectionBase.GetObjectByKey(ObjectKeyBase key)
   at Microsoft.SqlServer.Management.Smo.DatabaseCollection.GetObjectByName(String name)
   at Microsoft.SqlServer.Management.Smo.DatabaseCollection.get_Item(String name)
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype.GetDatabaseDefaultInitFields(Server server) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype.cs:line 1688
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype.cs:line 1757
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype80..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype80.cs:line 188
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype80SP3..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype80SP3.cs:line 34
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype90..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype90.cs:line 220
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype100..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype100.cs:line 189
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype110..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype110.cs:line 145
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype130..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype130.cs:line 33
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype140..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype140.cs:line 24
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype150..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype150.cs:line 20
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototype160..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototype160.cs:line 21
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabasePrototypeAzure..ctor(CDataContainer context, DatabaseEngineEdition editionToCreate) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabasePrototypeAzure.cs:line 42
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabaseTaskHelper.Initialize(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabaseTaskHelper.cs:line 62
   at Microsoft.SqlTools.ServiceLayer.Admin.DatabaseTaskHelper..ctor(CDataContainer context) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/Database/DatabaseTaskHelper.cs:line 46
   at Microsoft.SqlTools.ServiceLayer.Admin.AdminService.CreateDatabaseTaskHelper(ConnectionInfo connInfo, Boolean databaseExists) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/AdminService.cs:line 285
   at Microsoft.SqlTools.ServiceLayer.Admin.AdminService.GetDatabaseInfo(ConnectionInfo connInfo) in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/AdminService.cs:line 271
   at Microsoft.SqlTools.ServiceLayer.Admin.AdminService.<>c__DisplayClass12_0.<<HandleGetDatabaseInfoRequest>b__0>d.MoveNext() in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/AdminService.cs:line 147
--- End of stack trace from previous location ---
   at Microsoft.SqlTools.ServiceLayer.Admin.AdminService.<>c__DisplayClass12_0.<<HandleGetDatabaseInfoRequest>b__1>d.MoveNext() in /_/src/Microsoft.SqlTools.ServiceLayer/Admin/AdminService.cs:line 156
   --- End of inner exception stack trace ---
  Code: 0 

Azure Data Studio version: azuredatastudio 1.50.0 (49c73a8, 2024-11-17T22:41:05.327Z)
OS version: Windows_NT x64 10.0.22631
Restricted Mode: No
Preview Features: Enabled
Modes:

System Info

Item	Value
CPUs	AMD EPYC 7763 64-Core Processor (16 x 2445)
GPU Status	2d_canvas: unavailable_software canvas_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 skia_graphite: disabled_off video_decode: disabled_software video_encode: disabled_software vulkan: disabled_off webgl: unavailable_software webgl2: unavailable_software webgpu: unavailable_software webnn: disabled_off
Load (avg)	undefined
Memory (System)	63.95GB (31.70GB free)
Process Argv
Screen Reader	no
VM	0%

Extensions: none