MicrosoftSqlToolsServiceLayer seems to hang with 200% cpu, no output

[unhammer]

As soon as I click the SQL server disconnected in the modeline, select my server and try connecting, MicrosoftSqlToolsServiceLayer starts using 200% cpu, but it still says "disconnected" (and of course nothing works). I did (setq lsp-mssql-log-debug-info t) but neither the *sql* nor *sql::stderr* buffers show any output.

If I click it again, I get

LSP :: Failed to connect with the following error error number: 0
nil

Is there a way to get more debug info?

[yyoncho]

You may set lsp-print-io to t and check what the server has returned. My guess is that the service layer is unable to connect to your mssql instance. Use lsp-workspace-show-log after setting lsp-print-io to t to view the logs.

[unhammer]

Does mssql.log tell you anything? I don't see any clues :( The 100% cpu starts at line 273