Unable to connect to Fabric SQL Database from MSSQL extension using connection string

[mksuni]

• MSSQL Extension Version: 1.29.1
• VSCode Version: 1.98.2
• OS Version: Windows 11 Enterprise 24H2 Build 26100.3476

Steps to Reproduce:

1. Install MSSQL extension
2. Add new connection
3. Choose connection string
4. Pass a fabric SQL DB's ADO.NET connection string
5. Error occurs as shown below

mssql: Failed to connect: Microsoft.Data.SqlClient.SqlException (0x80131904): User account not received.
---> System.Exception: User account not received.
at Microsoft.SqlTools.Authentication.Authenticator.GetTokenAsync(AuthenticationParams params, CancellationToken cancellationToken) in //src/Microsoft.SqlTools.Authentication/Authenticator.cs:line 135
at Microsoft.SqlTools.Authentication.Sql.AuthenticationProvider.AcquireTokenAsync(SqlAuthenticationParameters parameters) in //src/Microsoft.SqlTools.Authentication/Sql/AuthenticationProvider.cs:line 90
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.<>c__DisplayClass147_1.<b__1>d.MoveNext()
--- End of stack trace from previous location ---

[croblesm]

Thanks for reporting this issue @mksuni. I'm also experiencing a similar problem:

mssql: Failed to connect: Microsoft.Data.SqlClient.SqlException (0x80131904): DefaultAzureCredential failed to retrieve a token from the included credentials. See the troubleshooting guide for more information. https://aka.ms/azsdk/net/identity/defaultazurecredential/troubleshoot - EnvironmentCredential authentication unavailable. Environment variables are not fully configured. See the troubleshooting guide for more information. https://aka.ms/azsdk/net/identity/environmentcredential/troubleshoot - WorkloadIdentityCredential authentication unavailable. The workload options are not fully configured. See the troubleshooting guide for more information. https://aka.ms/azsdk/net/identity/workloadidentitycredential/troubleshoot - ManagedIdentityCredential authentication unavailable. No response received from the managed identity endpoint. - Visual Studio Token provider can't be accessed at /Users/carlos/.IdentityService/AzureServiceAuth/tokenprovider.json - Azure CLI authentication failed du...