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.
Hi maxmerchant ,
Is my follow-up just to ask if the problem has been solved?
If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?
Thank you very much for your cooperation!
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!