topic Re: "This SQL database has been disabled." error message in SQL database

"This SQL database has been disabled." error message

Jerome22 — Mon, 19 May 2025 17:34:46 GMT

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?

Re: "This SQL database has been disabled." error message

burakkaragoz — Wed, 21 May 2025 11:28:40 GMT

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:

Fabric Capacity Status – make sure your capacity is active and not paused or suspended.
Go to Admin Portal > Capacity Settings, and ensure the SQL Endpoint feature is enabled.
Confirm that your workspace is assigned to a Fabric capacity (not just Pro).
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.

Re: "This SQL database has been disabled." error message

Jerome22 — Wed, 21 May 2025 11:31:21 GMT

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.

Re: "This SQL database has been disabled." error message

burakkaragoz — Wed, 21 May 2025 11:33:19 GMT

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 😊

Re: "This SQL database has been disabled." error message

djurecic — Fri, 23 May 2025 15:14:06 GMT

Hi Jerome22 ,

Thanks for your response. Do you have a source saying it is a known issue?

I'm not seeing this on either of these known issues lists

https://learn.microsoft.com/en-us/fabric/known-issues/fabric-known-issues

https://support.fabric.microsoft.com/en-US/known-issues/

Re: "This SQL database has been disabled." error message

Jerome22 — Fri, 23 May 2025 20:12:43 GMT

I don't have it.

during my call to the support team they inform me about this issue.

as it's a preview feature, I think it's not documented yet.

preview features are not officialy supported (so use them at your own risk... 😉 )

Re: "This SQL database has been disabled." error message

djurecic — Fri, 23 May 2025 20:27:30 GMT

Jerome22 Gotcha- thanks for sharing. Got this error message earlier today and there isn't much out there on it.

Re: "This SQL database has been disabled." error message

v-lgarikapat — Thu, 29 May 2025 08:24:09 GMT

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.

Re: "This SQL database has been disabled." error message

Shu_Ki — Tue, 09 Dec 2025 02:29:47 GMT

See here: https://support.fabric.microsoft.com/known-issues/?product=Databases&active=true&fixed=true&sort=published&issueId=1170