topic Issue Accessing Lakehouse with SQL Analytics Endpoint 5(Access is denied.) in SQL database

Issue Accessing Lakehouse with SQL Analytics Endpoint 5(Access is denied.)

OlenaDumna — Thu, 26 Dec 2024 11:29:37 GMT

Hello, All

I am an administrator for a Fabric workspace, and I have encountered an issue when accessing our Lakehouse data.

When I access the Lakehouse with the type "Lakehouse" (standard view), I can see the data in the tables without any issues. However, when I access the Lakehouse with the type "SQL Analytics Endpoint,"
I receive the following error message:

Error: "Encountered operating system error 5(Access is denied.) while attempting to read physical metadata."

I suspect this issue might be related to previous work done by a colleague who has since left our company.
As a result, I’m not sure if there are any permissions or configurations that were missed during the transition.

Could you please assist me in resolving this issue?
Any guidance on how to properly configure or troubleshoot this would be greatly appreciated.

Uptdate :
I have takeover SQL Analytics Endpoint , but it didn't help.
As result as for now owner of Lakehouse - Lakehouse is a colleague who has since left our company.
ownet of Lakehouse - SQL Analytics Endpoint is me.

Re: Issue Accessing Lakehouse with SQL Analytics Endpoint 5(Access is denied.)

Anonymous — Fri, 27 Dec 2024 05:24:50 GMT

Hi OlenaDumna ,

You may reassign the ownership of the Lakehouse an active user within your organization.

For original post you could refer to :Re: Transfer ownership of a Fabric Lakehouse - Microsoft Fabric Community

Then verify that the new owner has the necessary permissions to access and manage the Lakehouse. You may need to update the permissions settings to ensure that the new owner has full access.

Best Regards,
Community Support Team _ Caitlyn

Re: Issue Accessing Lakehouse with SQL Analytics Endpoint 5(Access is denied.)

OlenaDumna — Sat, 28 Dec 2024 12:50:22 GMT

Hi, v-xiaoyan-msft

Preview

I already did this yesterday.
As you can see I am owner but not able to execute select query.

So I don't understant what else I should check ... but I need to fix this
May be it is because of that I am only owner od SQL endpoint.