[Bug]: Can't connect to Fabric items endpoint

[ritaipf]

Description

Issue described here in MSFabric blogpost, with screenshots provided there as well:

https://community.fabric.microsoft.com/t5/Data-Engineering/VSCode-SQLServer-Extension-Can-t-connect-to-Lakehouse-endpoint/m-p/5180837#M16172

Unable to connect to lakehouse sql analytics endpoint or to any other warehouse in fabric using the extension and Micorosft Entra ID MFA.

Steps to Reproduce

1. Get SQL Analytics endpoint string from Fabric + Database name (it's usually the lakehouse name)
2. Add connection on SQL Server extension
3. Paste the sqn analytics endpont to 'server name' and the lakehouse/Db to 'database name'
4. Set authentication type to "Microsoft Entra ID - Universal with MFA support"
5. Specify you microsoft account
6. Encrypt = 'Mandatory'
7. Click "Test Connection" or "Connect"

as an alternative, use the "Browse Fabric" under "Input Type" to select the same lakehouse under same workspace.

Affected Area

• Connection dialog (SQL Server | Azure browse/Fabric browse)
• Query editor
• Query results panel
• Object Explorer
• GitHub Copilot integration
• Preview/Edit data
• Table Designer
• Schema Designer
• Schema Compare
• Local SQL Server Container provisioning
• SQL database in Fabric provisioning
• DACPAC/BACPAC export/import
• SQL Database projects
• Query Plan Visualizer
• Other (please describe below)

If you selected "Other", please describe the affected area

No response

Environment Information

• VS Code Version: 1.119.0
• MSSQL Extension Version: 1.42.2
• Operating System: Windows 11 Enterprise
• Connection Type: SQL Analytics Endpoint in Fabric and SQL database in Fabric

Confirmation

• I have searched existing issues and couldn't find a match
• I want to work on this issue