I am not able to create a new dedicated SQL pool

Question

I am not able to create a new dedicated SQL pool

Hitesh Narula 0

I am getting below error while creating dedicated sql pool. I have upgraded my account to pay as you go but it is not reflecting even after 2 days. Also not allowing me to add resources, when i try t add from usage+quotas the button to add new quotas is disabled. ErrorCreatingDedicateSQLPool

Nandan Hegde 35,356 Reputation points MVP Volunteer Moderator

2025-05-10T07:13:26.8966667+00:00

Are you able to proceed with creation of the dedicated pool with the minimum DWU level? or are you getting this error at all levels
Hitesh Narula 0 Reputation points

2025-05-11T02:30:42.48+00:00

I am getting this error at all levels
Hitesh Narula 0 Reputation points

2025-05-11T02:33:45.1566667+00:00

When I go to Usage + Quotas under my subscription, the link to create New Quota request is also disabled.
Hitesh Narula 0 Reputation points

2025-05-12T07:56:00.8333333+00:00

Microsoft.Synpase is already registered but it still doesn't show up on providers under usage+quotas. I think, will try another region
Krupal Bandari 420 Reputation points Microsoft External Staff Moderator

2025-05-12T08:29:17.62+00:00

In some cases, even after successful registration, Synapse may not immediately appear under the Usage + Quotas section. This usually means the initial quota hasn’t yet been initialized for your subscription in that region especially if Synapse resources were never created before.

Please try these steps:

Try Creating in Another Region:
Since you mentioned you're considering trying another region that’s a good next step. Regions like East US or West Europe often have broader availability and may already have quota pre-initialized for Synapse.

Create a Free DW100c Dedicated SQL Pool (If Region Allows):
If you haven't already, try provisioning a DW100c SQL pool in the new region sometimes this trigger automatic quota registration. Once it succeeds, you’ll usually be able to see Synapse under Usage + Quotas afterward.

Contact Microsoft Support to Initialize Quota:
If you need Synapse in the original region and still can’t see it in Usage + Quotas, the fastest path forward is to contact Microsoft Support and request manual quota initialization.

You can raise a free support request here (choose "Quota" as the issue type):
https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request
Krupal Bandari 420 Reputation points Microsoft External Staff Moderator

2025-05-13T03:59:30.31+00:00

Hi @Hitesh Narula ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Krupal Bandari 420 Reputation points Microsoft External Staff Moderator

2025-05-13T09:33:51.6633333+00:00

Hi @Hitesh Narula
Thanks for the update, and I'm glad to hear it worked in another region!

As expected, the original issue was likely due to Synapse quota not being initialized in the first region even though the resource provider was registered.

If you ever need to use that original region again, you can raise a free Microsoft support request to have the quota manually initialized:
https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request

3 answers

Your answer

Nandan Hegde 35,356 Reputation points MVP Volunteer Moderator

2025-05-10T07:13:26.8966667+00:00

Are you able to proceed with creation of the dedicated pool with the minimum DWU level? or are you getting this error at all levels
Hitesh Narula 0 Reputation points

2025-05-11T02:30:42.48+00:00

I am getting this error at all levels
Hitesh Narula 0 Reputation points

2025-05-11T02:33:45.1566667+00:00

When I go to Usage + Quotas under my subscription, the link to create New Quota request is also disabled.
Hitesh Narula 0 Reputation points

2025-05-12T07:56:00.8333333+00:00

Microsoft.Synpase is already registered but it still doesn't show up on providers under usage+quotas. I think, will try another region
Krupal Bandari 420 Reputation points Microsoft External Staff Moderator

2025-05-12T08:29:17.62+00:00

In some cases, even after successful registration, Synapse may not immediately appear under the Usage + Quotas section. This usually means the initial quota hasn’t yet been initialized for your subscription in that region especially if Synapse resources were never created before.

Please try these steps:

Try Creating in Another Region:
Since you mentioned you're considering trying another region that’s a good next step. Regions like East US or West Europe often have broader availability and may already have quota pre-initialized for Synapse.

Create a Free DW100c Dedicated SQL Pool (If Region Allows):
If you haven't already, try provisioning a DW100c SQL pool in the new region sometimes this trigger automatic quota registration. Once it succeeds, you’ll usually be able to see Synapse under Usage + Quotas afterward.

Contact Microsoft Support to Initialize Quota:
If you need Synapse in the original region and still can’t see it in Usage + Quotas, the fastest path forward is to contact Microsoft Support and request manual quota initialization.

You can raise a free support request here (choose "Quota" as the issue type):
https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request
Krupal Bandari 420 Reputation points Microsoft External Staff Moderator

2025-05-13T03:59:30.31+00:00

Hi @Hitesh Narula ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Krupal Bandari 420 Reputation points Microsoft External Staff Moderator

2025-05-13T09:33:51.6633333+00:00

Hi @Hitesh Narula
Thanks for the update, and I'm glad to hear it worked in another region!

As expected, the original issue was likely due to Synapse quota not being initialized in the first region even though the resource provider was registered.

If you ever need to use that original region again, you can raise a free Microsoft support request to have the quota manually initialized:
https://learn.microsoft.com/en-us/azure/azure-portal/supportability/how-to-create-azure-support-request

Answer 1

Hi @Hitesh Narula,
It seems like you're seeing the error at all DWU levels, the issue isn’t tied to just the performance tier it’s most likely because your Azure subscription lacks the necessary quota, or the required resource provider (Microsoft.Synapse) is not registered.

Even the lowest tier (DW100c) requires available quota in your selected region. If your subscription currently has no Synapse quota allocated, the creation will be blocked regardless of DWU level.

From your screenshot, I also noticed that the “New Quota Request” button is greyed out. This often happens when the Microsoft.Synapse resource provider isn’t registered yet.

To enable quota management and resource creation for Synapse, make sure the Microsoft.Synapse provider is registered.

Go to the Azure Portal
Navigate to Subscriptions and select your subscription
In the left-hand menu, click Resource providers
Search for Microsoft.Synapse
If it shows Not Registered, click Register. Wait 1–2 minutes for the status to change to Registered https://learn.microsoft.com/en-us/azure/azure-resource-manager/management/resource-providers-and-types#register-resource-provider

Once the provider is registered, go to Usage + Quotas in the Azure Portal, set the Provider filter to Azure Synapse then you should now be able to click New Quota Request. Submit a request to increase the DWU quota for your region, even DW100c requires quota availability

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-service-capacity-limits#request-a-quota-increase

If you're still blocked in your current region, consider creating the SQL pool in another supported region (e.g., East US, West Europe). https://azure.microsoft.com/en-us/explore/global-infrastructure/products-by-region/

I hope this helps! If you found this useful, please consider upvoting so others can benefit too.

Answer 2

Hitesh Narula 0

Hi @Krupal Bandari ,

The above didn't solved this issue so I created a new Synapse workspace in a different region. Then I was able to create a dedicated sql pool.

Answer 3

Hi @Hitesh Narula

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this!

Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Issue:

I am not able to create a new dedicated SQL pool

Solution:

I created a new Synapse workspace in a different region. Then I was able to create a dedicated sql pool.

Please click Accept Answer and kindly upvote it so that other people who faces similar issue may get benefitted from it.

Share via

I am not able to create a new dedicated SQL pool

3 answers

Your answer