TrustServerCertificate=true

[CJP143]

Describe the bug

I run #r "nuget: Microsoft.DotNet.Interactive.SqlServer, -" and it installs
• Microsoft.DotNet.lnteractive.SqlServer,1.UO-beta25160.1 fine and I used to use
#!connect mssql --kernel-name sqlconn --connection-string "Server=mydb; Database=mytbl;Trusted_connection=true"
but now get
Error: System.Exception: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)
which is fine as https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/certificate-chain-not-trusted?tabs=ole-db-driver-19 says to use ;TrustServerCertificate=true which again is fine but nothing happens the kernel just runs until I have to restart and I get no error messages.

part of log looks like the call fails for some reason but I get no message.
2025-03-26T09:44:38.1335309Z [00-26f13f87b68e3791897d36ff17ac5c20-d0149f4559aa06f0-00] ℹ ➡️ ConnectMsSqlKernel kernel://pid-18948/
2025-03-26T09:44:38.1335897Z [00-26f13f87b68e3791897d36ff17ac5c20-d0149f4559aa06f0-00] ℹ ⁞Ε⁞ CommandFailed Command failed: SubmitCode: #!connect mssql --kern ... (Command: SubmitCode, Token: LK8FxlFnRHyWi6yG5HtmeA==)
2025-03-26T09:44:38.1336142Z [00-26f13f87b68e3791897d36ff17ac5c20-d0149f4559aa06f0-00] ℹ ⬅️ CommandFailed kernel://pid-18948/csharp
2025-03-26T09:44:38.1337510Z [00-26f13f87b68e3791897d36ff17ac5c20-c905afc987ed6f71-00] ℹ ⁞Ε⁞ CommandFailed Command failed: SubmitCode: #!connect mssql --kern ... (Command: SubmitCode, Token: LK8FxlFnRHyWi6yG5HtmeA==)
2025-03-26T09:44:38.1337553Z [00-26f13f87b68e3791897d36ff17ac5c20-d0149f4559aa06f0-00] [KernelScheduler] [Run] ⏹ -> ✔ (2723.8331ms)

tried to use DOTNET_SQLTOOLSSERVICE_LOGFILE to see what messages returned but that failed with RPC error

Which version of .NET Interactive are you using? (In a notebook, run the #!about magic command. ):

• OS
  • Windows 11
  • [X ] Windows 10
  • macOS
  • Linux (Please specify distro)
  • iOS
  • Android
• Browser
  • Chrome
  • Edge
  • Firefox
  • Safari
• Frontend
  • Jupyter Notebook
  • Jupyter Lab
  • nteract
  • [ X] Visual Studio Code
  • Visual Studio Code Insiders
  • Visual Studio
  • Other (please specify)

Screenshots

If applicable, add screenshots to help explain your problem.