An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Hello David Omogbehin
Error SqlServerRegionDoesNotAllowProvisioning means that Azure SQL server provisioning is currently unavailable for your subscription in the selected region, and Synapse workspace creation depends on that SQL capability.
I suggest the following:
1)Make sure the required resource providers are registered:
az provider register --namespace Microsoft.Sql
az provider register --namespace Microsoft.Synapse
Check the status:
az provider show --namespace Microsoft.Sql --query registrationState
It should return Registered.
2)If Microsoft.Sql is already registered, try creating the Synapse workspace in another supported region such as North Europe or West Europe.
3)If you specifically need UK South or UK West, open an Azure Support request and ask for Azure SQL provisioning/region access for your subscription. Microsoft documents this error as potentially caused by subscription-level regional access or capacity restrictions.
Official documentation:
Resolve Azure SQL capacity and region errors
Register Azure resource providers
Create an Azure Synapse workspace
Since you are using a 30-day Azure credit, I would first try North Europe or West Europe so you can continue the lab without waiting for a regional access request.
Also, please edit the public post and mask the Subscription ID.