topic Re: Can't connect to a SQL endpoint from MS Fabric Lakehouse in Data Engineering

Can't connect to a SQL endpoint from MS Fabric Lakehouse

debiagui — Thu, 07 Aug 2025 18:06:37 GMT

We have a Lakehouse, and we're currently unable to connect to the SQL endpoint using SSMS, Power Query, or any other tool.

We’re getting a timeout error, and in SSMS the following message appears:

----

Msg 24551, Level 18, State 40, Line 1
Encountered operating system error 5(Access is denied.) while attempting to read physical metadata.

----

Also, when trying to access the SQL endpoint in Fabric, the tables are not being displayed.

But reanding data inside of a Notebook works.

The Lakehouse was working fine until yesterday.

Re: Can't connect to a SQL endpoint from MS Fabric Lakehouse

debiagui — Thu, 07 Aug 2025 18:08:17 GMT

I'm the workspace admin and also I'm the owner of the Lakehouse

Re: Can't connect to a SQL endpoint from MS Fabric Lakehouse

debiagui — Thu, 07 Aug 2025 20:15:06 GMT

know issue

Re: Can't connect to a SQL endpoint from MS Fabric Lakehouse

ToddChitt — Tue, 30 Sep 2025 14:09:19 GMT

I'm seeing the same thing today, about 50 days past this thread date. I am an Admin of the Workspace. I can query data from one Warehouse, but when I try on a second I get permission errors. Below is from SSMS:

debiagui You mention this is a KNOWN ISSUE. Do you have links to the Microsoft Status ticket for it?

Re: Can't connect to a SQL endpoint from MS Fabric Lakehouse

debiagui — Tue, 30 Sep 2025 14:51:22 GMT

Hi ToddChitt link to known issues: https://support.fabric.microsoft.com/known-issues/

That know issue was fixed, but you can take a look at the page, maybe is a different issue now.

Re: Can't connect to a SQL endpoint from MS Fabric Lakehouse

ToddChitt — Tue, 30 Sep 2025 17:06:50 GMT

Turns out it was the Warehouse Owner, they had not logged in to Fabric to renew their token in over 30 days. IMHO, ANYTHING created inside a Workspace needs to be owned by the WORKSPACE, and NOT dependent on other poeple or users.