Azure / SQL Server / This location is not available for subscription
Posted by Barac in Azure, Powershell, SQL Tips and Tricks on Oct 22nd, 2018 | 5 commentsDuring deployment of Azure SQL Server in Canada East location (new Azure Subscription) I got the following error:
Using Azure Portal
Using Powershell
At the same time if I list all available azure location for the current subscription I can see that Canada East is there
The reason is that Canada East region is not activated for my new Azure Subscription.
To resolve this issue just contact the Azure support to have this enabled for you. You can do this for free using support page on your Azure Portal.
Open a new support request
Describe your issue best as you can.
The Initial Response Time varies with both the support plan and the Business Impact of the request (also known as Severity).
In my case was 8 business hour for Severity C (Support Plans)
Useful link: Troubleshooting region or SKU subscription issues MS article.
Similar Posts:
- Azure / SQL Server / Cannot open user default database (Login failed)
- SQL Server / Initialize Secondary Database / Generate a full backup of the primary database using SSMS transaction log shipping GUI issue
- SQL Server / Monitor Backup and Restore progress
- Azure / SQL Server / Create DB on Azure
- Azure / PowerShell / Deploy Azure SQL database DR environment (PaaS) using PowerShell
5 Responses to “ “Azure / SQL Server / This location is not available for subscription”
Leave a Reply
About Me
My name is Zoran, currently living in Auckland, New Zealand. I am a data specialist with more than 15 years of hands-on experience in database administration and optimisation. I am also, Certified Microsoft Trainer (MCT) and Microsoft Certified Solutions Expert (MCSE) with a Master‘s degree in Information Technology. Sharing knowledge and contributing to the SQL Server community is my passion. I am also an organiser of the Auckland SQL User Meetup Group. As well I am active blogger and speaker at different SQL events such as SQL Saturdays, Meetups etc.
read moreAuckland SQL Group
MSDN PROFILE
SQL SERVER UPDATES
- Microsoft SQL Server 2022 Updates / Release Candidate (RC 1) Evaluation Edition (16.0.950.9)
- Microsoft SQL Server 2019 Updates / BETA (15.0.1000.34) / RTM (15.0.2000.5)
- Microsoft SQL Server 2017 Updates / RTM (14.0.1000.169)
- Microsoft SQL Server 2016 Updates / RTM (13.0.1601.5) / SP1 (13.0.4001.0 or 13.1.4001.0) / SP2 (13.0.5026.0 or 13.2.5026.0) / SP3 (13.0.6300.2 or 13.3.6300.2)
- Microsoft SQL Server 2014 Updates / RTM (12.0.2000.0) / SP1 (12.0.4100.1 or 12.1.4100.1) / SP2 (12.0.5000.0 or 12.2.5000.0) / SP3 (12.0.6024.0 or 12.3.6024.0)
- Microsoft SQL Server 2012 Updates / RTM (11.00.2100) / SP1 (11.0.3000.0 or 11.1.3000.0) / SP2 (11.0.5058.0 or 11.2.5058.0) / SP3 (11.0.6020.0 or 11.3.6020.0) / SP4 (11.0.7001.0 or 11.4.7001.0)
I shouldnt have to submit a ticket, they give us a free 30 day trial but we get a roadblock with location not available? are you kidding me?! dumbest shit ive ever seen, i have zero tolerance for lack of common sense.
you want us to try your software and possibly become a long time member? then fix that stupid bullshit!!
Hi Steve, I appreciate your feedback regarding this matter.
Worth mentioning … due to current situation Microsoft placed limits on free offers to prioritize capacity for existing customers. They also have limits on certain resources for new subscriptions.
More information regarding this …
https://social.msdn.microsoft.com/Forums/en-US/3865be66-8d81-443d-902b-8e5a8a34fbe7/ongoing-issue-unable-to-provision-azure-sql-database?forum=ssdsgetstarted
https://azure.microsoft.com/en-us/blog/update-2-on-microsoft-cloud-services-continuity/
This also happens for existing paying customers so does seem pretty stupid.
Yes! This still happening, mainly in Europe areas.
Yeah, similar is happening in Asia Pacific Azure global region, specifically Australia locations.