Forum Discussion

amolt's avatar
amolt
Resolver I
1 year ago
Solved

Internal error SqlLoginFailureException

Hello, 

I can no longer use the SQL endpoint of some Lakehouses.
I've tried refreshing the metadata, but I consistently get the error message “Internal error SqlLoginFailureException”

does anyone have any ideas?

data engineering
Lakehouse

11 Replies

  • Srisakthi's avatar
    Srisakthi
    Super User
    1 year ago

    Hi amolt ,

     

    Can you check who is the owner of the Lakehouse?. This issue may occur if the owner of the lakehouse's credential expired

     

    Regards,

    Srisakthi

    • amolt's avatar
      amolt
      Resolver I
      1 year ago

      hi Srisakthi,

       

      Thanks for your reply.
      I'm the lakehouse owner and I don't have the problem on all lakehouses.

      Regards, 

      Alexis

    • Srisakthi's avatar
      Srisakthi
      Super User
      1 year ago

      Hi amolt ,

      How you are refreshing the metadata. Are you using api?

       

      Regards,

      Srisakthi

      • amolt's avatar
        amolt
        Resolver I
        1 year ago

        Srisakthi ,

        I've had this problem with other lakehouses, but refresh of the metadata solved the problem.
        In this case, I get the error message during the metadata refresh.

         

        Regards,

        Alexis

  • v-kathullac's avatar
    v-kathullac
    Community Support
    1 year ago

    Hi amolt ,

     

    Thank you for reaching out to Microsoft Fabric Community Forum.

     

    can you try the below debug to steps to solve your issue.

     

    • Ensure you have the correct permissions on the Lakehouse (e.g., Lakehouse Contributor or higher).

    • Check if the SQL analytics endpoint is enabled in the Lakehouse settings.

    • Sign out and back in to refresh your authentication token.

    • Clear browser cache if you're using the Fabric portal.

    • Verify that the Lakehouse or workspace hasn’t been renamed or moved.

    • Make sure you're using the latest SQL endpoint URL.

    • Try connecting using a different tool (e.g., SSMS, Azure Data Studio, Power BI Desktop).

    • Check the Microsoft Fabric status page for any ongoing issues.

    • Review the Power BI Support Portal for related incidents.

    • Raise a Microsoft support ticket if the issue persists.

    beow is the link to raise support ticket : https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

     

    Regards,

    Chaithanya.

     

  • v-kathullac's avatar
    v-kathullac
    Community Support
    1 year ago

    Hi amolt ,

     

    Just checking, have you had a chance to open a support ticket, as suggested. If so, we'd love to hear the current status or any updates from that.

     

    If the issue was resolved through the support ticket, it would be great if you could share the solution here as well. It could really help other community members find answers more quickly.

     

    Warm regards,

    Chaithanya.