An Azure managed MySQL database service for app development and deployment.
Hi,
A response of 500 InternalServerError when calling Location Based Capability Set - Get means that your subscription is blocked from provisioning in that region (UK South in this case). Due to capacity limitations a large number of subscriptions have been blocked from deploying MySQL Flexible Server to the most popular regions (UK South is one).
One thing you try is to create a free Service and subscription limits (quotas) request and request access to and/or increase your MySQL Flexible quota for UK South region.
To start the process, please click link below:
https://portal.azure.com/#create/Microsoft.Support
Issue type: Service and subscription limits (quotas)
Quota type: Azure Database for MySQL Flexible Server
Click Next
On Additional details tab, click Enter details. Select Region access or Quota increase, select region, select other details as needed, Save. Continue filling out Additional details tab, click Next, review and Create the case. You should receive automated email within minutes.
If you want you can check different regions to see if the region is blocked. Click link above, click Try It button, sign in, select your Tenant. Fill out as below:
capabilitySetName: default
locationName: uksouth
Scroll down and click Run button.
If you see response code 200 and Body box contains list of SKUs/Features, you know you have access to the region. If you see response code 500 and Body box has InternalServerError, you know you don't have access to the region.
You may repeat the above test for different regions by changing the location and clicking Run again.
If you have any questions please add a comment below.
Please click Accept Answer and upvote if the above was helpful.
Thanks.
-TP