Forum Discussion

Timal's avatar
Timal
Helper I
2 years ago
Solved

SQL-Endpoint not working anymore

Hello,   Since today im Experiencing issues with the SQL-Endpoints from my Warehouses and also Lakehouses. I can access Data with Spark (Lakehouse) but i cannot Access Data via the SQL Endpoint ne...
data warehouse
Warehouse
  • Timal's avatar
    Timal
    2 years ago

    I've found the issue. The user who created the Warehouses/Lakehouses has been deactivated.

    Du to the Warehouses using delegate Permissions from the Owner for other users to access the Data, the User cannot be removed from the Workspace or Access will break.

    According to the following Guide PowerShell can be used to change Ownership.

    Change ownership of Fabric Warehouse - Microsoft Fabric | Microsoft Learn

    However so far this only worked with Warehouses and NOT Lakehouses for me.

    Hope this helps! ... and i find out how to fix the Lakehouses

     

    EDIT:

    Microsoft confirmed that the Owner of Lakehouses currently can only be changed by them. So you'll have to open a Ticket. They plan to allow the end user to change that in the future.

    I don't understand why the Access to the Warehouses is not managed via Service Principal (like other Services) instead of User Delegation but it is what it is.

Timal's avatar
Timal
Helper I
2 years ago

I've found the issue. The user who created the Warehouses/Lakehouses has been deactivated.

Du to the Warehouses using delegate Permissions from the Owner for other users to access the Data, the User cannot be removed from the Workspace or Access will break.

According to the following Guide PowerShell can be used to change Ownership.

Change ownership of Fabric Warehouse - Microsoft Fabric | Microsoft Learn

However so far this only worked with Warehouses and NOT Lakehouses for me.

Hope this helps! ... and i find out how to fix the Lakehouses

 

EDIT:

Microsoft confirmed that the Owner of Lakehouses currently can only be changed by them. So you'll have to open a Ticket. They plan to allow the end user to change that in the future.

I don't understand why the Access to the Warehouses is not managed via Service Principal (like other Services) instead of User Delegation but it is what it is.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Timal ,

Thank you for your reply, I am very glad you found the problem. Can I ask if your problem is solved at the moment, please feel free to ask me any questions you may have. If the problem has been resolved, I suggest you could mark your reply as a solution, it looks like it could help more people experiencing similar problems!

 

Best Regards,

Ada Wang