projectkudu / slingshot

This project implements the Deploy To Azure button
http://azure.microsoft.com/blog/2014/11/13/deploy-to-azure-button-for-azure-websites-2/
51 stars 20 forks source link

SQL Server location list contains forbidden regions #77

Open artem-dudarev opened 7 years ago

artem-dudarev commented 7 years ago

The setup form has Sql Server Location parameter with the list of all available locations. When I select Brazil South and try to deploy the SQL server I get the following error for one of my subscriptions:

Your subscription offer type does not support provisioning of a new server version 12.0 in Brazil South region. Please choose a different region or contact Microsoft Support for an exception.

image image

For another subscription the deployment fails even if I select West US:

MSDN subscriptions are restricted from provisioning in this region. Please choose a different region. For exceptions to this rule please contact Microsoft Support.

image image

I believe if some region is not available for the selected subscription then it should not be included in the Sql Server Location list. Currently this list contains forbidden regions: image

Here is the test repository: https://github.com/artem-dudarev/testdeploy3

rfabro commented 4 years ago

Updates on this? I only able to create a new SQL Server whenever I choose a region where I am nearest which is Southeast Asia. Every other region will throw me the same error.

patrickebates commented 4 years ago

The region list is populated by Azure itself. We have no control over it. I suggest opening a ticket with Microsoft.