If you cannot create an Azure SQL Database Server in any region, it may be due to your subscription not having access to those regions. To resolve this issue, you need to file a support request to enable access to specific regions for your subscription. You can do this by following the steps outlined in the Azure documentation for resolving capacity errors.
If you encounter errors such as:
-
Your subscription does not have access to create a server in the selected region. -
Provisioning is restricted in this region. Please choose a different region. -
Location 'region name' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'subscription id' at this time, you should open a support ticket to request access to the desired region.
Additionally, ensure that your subscription is registered with the SQL resource provider (RP) to enable the creation of servers in the selected region.