SQL Database: Zone Redundancy Deployment Error — Provisioning Disabled

Question

SQL Database: Zone Redundancy Deployment Error — Provisioning Disabled

BWilson-1307 0

Problem description

I am attempting to enable zone redundancy on my Azure SQL elastic pool, but I encounter an error stating 'Provisioning of zone redundant database/pool is not supported for your current request.' The operation fails both via Terraform and the Azure Portal, specifically on the East US 2 region.

Environment

Azure SQL Database elastic pool in the East US 2 region.

What I've already tried

I have attempted to create or update the elastic pool with zone redundancy enabled, using both Terraform scripts and the Azure Portal. The Terraform configurations specify the Business Critical tier, appropriate vCores, and zone redundancy. I also verified the SKUs and region support using Azure CLI commands, which confirmed availability of zone redundancy in East US 2. Despite these efforts, the deployment consistently fails with the provisioning disabled error.

Note: The exact same Terraform scripts successfully deploy zone redundant elastic pools in the CentralUS region. Our issue is limited to EastUS2 only.

Current status

The issue persists despite confirming region support and trying different deployment methods. I am seeking guidance on whether this is a regional limitation, a specific configuration issue, or if additional steps are necessary to enable zone redundancy in East US 2.

SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator

2026-09-26T07:37:03.1066667+00:00

Hi @BWilson-1307

Thank you for posting your query on Microsoft Q&A platform.

We are looking into this issue and will keep you posted updates.

Thanks,
SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator

2026-09-30T01:04:24.2133333+00:00
Hi @BWilson-1307 ,

Hello BWilson,

Thank you for providing the detailed information and for confirming that the same Terraform configuration works successfully in Central US.

Based on the scenario described, this does not appear to be a Terraform-specific configuration issue.
Zone redundancy support

Azure SQL Database supports zone redundancy for Business Critical single databases and elastic pools in regions that support availability zones. Therefore, using a Business Critical elastic pool with zone redundancy is a supported configuration when the required regional and subscription-level availability is present.

The important distinction here is between:

The Azure region/SKU supporting zone redundancy.

Your specific subscription being able to provision the requested zone-redundant capacity in that region.

Your Azure CLI validation confirms that the capability is offered for the SKU/region, but the actual deployment is being rejected with:

Provisioning of zone redundant database/pool is not supported for your current request.

Since the identical configuration works in Central US and fails through both Terraform and the Azure Portal in East US 2, the next step should be to verify whether Zone Redundant Access (Availability Zones) is enabled/available for the affected subscription in East US 2.
Recommended resolution

Please create an Azure support request for the affected subscription:
Azure Portal → Help + support → Create a support request

Select:

Issue type: Service and subscription limits (quotas)

Quota type: SQL database

Quota: Zone Redundant Access (Availability Zones)

Location: East US 2

Specify the expected vCore requirement for the Business Critical elastic pool.

Once the request has been reviewed, retry the deployment with the existing Terraform configuration or through the Azure Portal.
Why I recommend this path

The fact that:

Business Critical elastic pools support zone redundancy,

the configuration works in Central US,

the failure occurs only in East US 2,

and both Terraform and Azure Portal return the same provisioning restriction,

makes it unlikely that changing the Terraform syntax alone will resolve the issue.

If Zone Redundant Access is already approved for this subscription in East US 2 and the deployment continues to fail, then I recommend opening an Azure SQL support request and providing the failed deployment's Activity Log details, including the correlation ID, timestamp, subscription ID, region, elastic pool SKU/vCores, and complete error response so that the provisioning failure can be investigated.

Microsoft documentation:

Enable zone redundancy for Azure SQL Database https://learn.microsoft.com/azure/azure-sql/database/enable-zone-redundancy

Azure SQL Database feature availability by region https://learn.microsoft.com/azure/azure-sql/database/region-availability

Hope this helps.

1 answer

Your answer

SIVASANKAR YEDDULA 170 Reputation points Microsoft External Staff Moderator

2026-09-26T07:37:03.1066667+00:00

Hi @BWilson-1307

Thank you for posting your query on Microsoft Q&A platform.

We are looking into this issue and will keep you posted updates.

Thanks,

Answer 1

Hi BWilson-1307,

Thanks for the detailed write-up. The fact that the same Terraform succeeds in Central US but fails in East US 2 is actually the key clue here, so let me explain what's going on.

This error isn't caused by your Terraform or Portal configuration at all. Zone Redundant Access (Availability Zones) is a per-subscription quota that Microsoft has to grant separately for each region. East US 2 supports zone redundancy as a service, but your subscription hasn't yet been approved to use it there. That's why the CLI checks came back clean (they only confirm the region/SKU supports ZR in general, not whether your subscription has the allocation) while the deployment itself is still blocked.

Now, how to fix it]:

Go to Azure Portal > Help + support > Create a support request
Issue type: Service and subscription limits (quotas)
Quota type: SQL Database
On the quota details page, select Zone Redundant Access (Availability Zones)
Set Location = East US 2, and enter the expected vCore consumption (use the total vCores for the pool tier you're deploying, with a bit of headroom for future scaling)
Submit

This is a no-cost quota request (doesn't require a paid support plan), and turnaround is typically 1-2 business days. Once it's approved, your existing Terraform should deploy without any changes.

A couple of side notes in case they're relevant to your setup:

If this pool is part of a failover group with a secondary elsewhere, the same error can surface if the secondary region doesn't support zones yet. The documented workaround there is to enable/disable HA through active geo-replication when creating the secondary, then add it to the failover group afterward.
Worth a quick check that no subscription-level Azure Policy is restricting zoneRedundant on SQL resources, though given it works fine in Central US this is unlikely to be the cause.

If this answers your question, please consider marking it as the accepted answer or upvoting it so other users hitting the same error can find it more easily. Let us know how the quota request goes, happy to help further if it's still blocked afterward.