Forum Discussion
VSCode SQLServer Extension - Can't connect to Lakehouse endpoint
Hello, I've been using VSCode along with its SQL Server Extension to connect to the SQL Analytics endpoint of a Lakehouse in a Fabric Workspace that i have "Admin" role on.
Today while starting my daily work I am unable to connect to it and I have no idea why. Nothing has been changed setupwise but everytime I try to connect, it just pops-up the window to re-authenticate -> browser window open to login in microsfot -> then pop-up appears again in vscode -> loging again -> failure and message "mssql: Error 18456: Could not login because the authentication failed." and not more detail about what failed.
I have tried creating new connection as well, and same error, when I try to 'Browse Fabric' is same thing.
When I try in SSMS, by using the browse methog, i get a longer error but I still have no idea what it means
Anyone facing similar issues or that could help in this case?
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.
13 Replies
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
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
Awesome, thanks for the info, dowgraded to version 1.41.0 did work.
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.Thank 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
