Select-AzureSubscription: The Subscription Name/ID Doesn’t Exist

I was working through a lab today where I was attempting to deploy a SQL Database (among other things) to Azure.  The deployment failed because of the error ‘The Central US region is not accepting new SQL Databases at this time’.  I then tried the North Central Region and received an error that ‘MSDN subscriptions are restricted from provisioning in this region. Please choose a different region. For exceptions to this rule please contact Microsoft Support.’  I found this pretty strange given but quickly found a blog post talking about how to find out which region(s) you were allowed to deploy to with your MSDN subscription.  Based on the list I eventually got, it doesn’t look to me like there are any restrictions on the region.

This screenshot shows the process I went through to figure this out and the problem I ran into because I was in a hurry and not paying attention. Get-AzureLocation is the command for the Classic portal. I needed to be using Get-AzureRMLocation instead.

The Output of Get-AzureRMLocation looks like this.  I changed my template to the WestUS region and for whatever reason that magically worked.

$ >(Get-AzureRMLocation).Location | Sort
australiaeast
australiasoutheast
brazilsouth
canadacentral
canadaeast
centralindia
centralus
eastasia
eastus
eastus2
japaneast
japanwest
koreacentral
koreasouth
northcentralus
northeurope
southcentralus
southeastasia
southindia
uksouth
ukwest
westcentralus
westeurope
westindia
westus
westus2