Forum Discussion
Advocate IVSCode SQLServer Extension - Can't connect to Lakehouse endpoint
Heyy, in the meantime i've reported a bug in the vscode extension and found other people with same issue https://github.com/microsoft/vscode-mssql/issues/22097
Hi ritz,
Thanks for clarifying. Since you're able to connect successfully through SQL Server Management Studio by manually entering the connection details, this confirms that the core connectivity is working as expected. The issue appears to be specific to the Browse Fabric experience in SSMS.
As this seems separate from the MSSQL extension for Visual Studio Code issue you already reported in Visual Studio Code, please go ahead and report this behavior through the appropriate SSMS feedback/support channel so the relevant team can investigate it further. Sharing the exact error message, SSMS version, and screenshots/logs would be helpful.
Thank you.
This happens to me too since yesterday. Can't even connecto to Fabric SQL analytics endpoint via the MSSQL extensionin VsCode. This is so annoying. They must have changed something
Hi ritz ,
Thank you for providing the update. From your description, it appears that this issue is more likely related to the Fabric service rather than a local configuration problem, particularly since the connection previously worked and began failing without any changes on your end.
The successful authentication prompt followed by Error 18456 indicates that the request is reaching the SQL endpoint but is being denied during the final validation step.
Additionally, similar incidents have been reported by other users recently, which suggests a potential backend issue instead of something specific to your environment. If the problem persists, please consider checking the Fabric service health and submitting a support ticket to Microsoft with the correlation ID from the failed login attempt so their team can investigate further.
For your reference, you can review Microsoft’s documentation on SQL analytics endpoint connectivity here: https://learn.microsoft.com/en-us/fabric/database/sql/sql-analytics-endpoint and Warehouse connectivity requirements here: https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity.
Thank you.
ritzThank you, as an update I'm able to connect using SSMS, but vscode extension still doesn't work, so i've raised an issue here [Bug]: Can't connect to Fabric items endpoint · Issue #22099 · microsoft/vscode-mssql
Hi ritz ,
Thanks for the update. Glad to hear SSMS is working now. It seems the issue is specific to the VS Code extension. Please let us know if you need anything else from our side.
Thank you.- ritz
Hello, SSMS is working when I specify the conneciton parameters, but If I use the 'browse Fabric' inside SSMS it still gives the error, should I open a bug report for that?