Forum Discussion
SQL EndPoint of a Lakehouse not working even after changing ownership
We were finally able to resolve this issue.
We had a warehouse in the same workspace (WH_A) which was created by the user (user A) that is no longer with the organization. We used the instructions provided in the link below to change the ownership of the warehouse to another user (user B). And now the SQL EndPoint of the lakehouse (LH_A) is working fine and we no longer see this error.
https://learn.microsoft.com/en-us/fabric/data-warehouse/change-ownership
We also did the same thing to resolve the SQL EndPoint error with another Lakehouse in another workspace i.e, changed the owner of the WH from inactive user to an active user. And it worked on that lakehouse too.
Not sure how the changing the ownership of the warehouse resulted in the lakehouse endpoint working but glad it did.
We were finally able to resolve this issue.
We had a warehouse in the same workspace (WH_A) which was created by the user (user A) that is no longer with the organization. We used the instructions provided in the link below to change the ownership of the warehouse to another user (user B). And now the SQL EndPoint of the lakehouse (LH_A) is working fine and we no longer see this error.
https://learn.microsoft.com/en-us/fabric/data-warehouse/change-ownership
We also did the same thing to resolve the SQL EndPoint error with another Lakehouse in another workspace i.e, changed the owner of the WH from inactive user to an active user. And it worked on that lakehouse too.
Not sure how the changing the ownership of the warehouse resulted in the lakehouse endpoint working but glad it did.