Forum Discussion

Jerome22's avatar
Jerome22
Resolver I
1 year ago
Solved

"This SQL database has been disabled." error message

Hi,

 

I'm just receiving this error message when accessing any of my SQL Databases:

This SQL database has been disabled. Please reach out to your Fabric Capacity administrator for more information.

 

I'm the admin, no matter the options I change the error still there.

any idea?

why my SQL databases has been disabled? and how to enable them again?

Need Help
SQL database
  • Jerome22's avatar
    Jerome22
    1 year ago

    I opened a support ticket.

    it's a known issue.

    when you pause a capacity this disabled the SQL Databases, opening a ticket is the only option to enable them back. (for now)

     

    pausing a capacity has multiple issues, mirrored cosmosdb databases is also impacted, you have to stop and restart the mirror after a pause of a capacity.

8 Replies

  • burakkaragoz's avatar
    burakkaragoz
    Super User
    1 year ago

    Hi Jerome22 ,

     

    If you're seeing the message "This SQL database has been disabled", even as an admin, here are a few things to check:

    1. Fabric Capacity Status – make sure your capacity is active and not paused or suspended.
    2. Go to Admin Portal > Capacity Settings, and ensure the SQL Endpoint feature is enabled.
    3. Confirm that your workspace is assigned to a Fabric capacity (not just Pro).
    4. If everything looks fine, check the Microsoft Fabric Status Page – it might be a temporary service issue.

    Let me know what you find – happy to help troubleshoot further!

    If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

    • Jerome22's avatar
      Jerome22
      Resolver I
      1 year ago

      I opened a support ticket.

      it's a known issue.

      when you pause a capacity this disabled the SQL Databases, opening a ticket is the only option to enable them back. (for now)

       

      pausing a capacity has multiple issues, mirrored cosmosdb databases is also impacted, you have to stop and restart the mirror after a pause of a capacity.

      • burakkaragoz's avatar
        burakkaragoz
        Super User
        1 year ago

        Thanks for the update Jerome22 – that’s super helpful!

        So just to summarize for others:

        • Pausing a Fabric capacity disables SQL databases, and currently the only way to re-enable them is by opening a support ticket.
        • This also affects mirrored Cosmos DB databases, which need to be manually restarted after a pause.

        Definitely something to keep in mind when managing capacity!

        If my response helped clarify things, kindly mark it as the Accepted Solution to assist others. And of course, a 'Kudos' is always appreciated 😊

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

    Hi Jerome22 ,

    Thanks for reaching out to the Microsoft fabric community forum.
    Hi djurecic , burakkaragoz   Thanks for your prompt response.
    Jerome22 

    If this post helped resolve your issue, please consider giving it Kudos and marking it as the Accepted Solution. This not only acknowledges the support provided but also helps other community members find relevant solutions more easily.

    We appreciate your engagement and thank you for being an active part of the community.

    Best regards,
    LakshmiNarayana.