Unable to create SQL Server in West US 2 region

Anikesh Das 20 Reputation points
2026-08-11T01:34:43.8233333+00:00

HI, I'm unable to create SQL Server in West US 2 region under MCAPS-Hybrid-REQ- subscription

Azure SQL Database
0 comments
Answer accepted by question author
JananiRamesh-MSFT 29,536 Reputation points Moderator
2026-08-11T09:24:24.6166667+00:00

@Anikesh Das Thanks for reaching out, as per our discussion internally posting the answer below

Issue: Unable to create SQL Server in West US 2 region under MCAPS-Hybrid-REQ- subscription.

Root Cause: The subscription has an Azure Policy that enforces Microsoft Entra ID authentication only for SQL Server. The customer was attempting to create the SQL Server with mixed authentication (SQL + Entra), which was blocked by the policy.

Resolution: Select "Microsoft Entra authentication only" as the authentication method during SQL Server creation instead of "SQL and Microsoft Entra authentication." This satisfies the subscription's policy requirement and allows the server to be created successfully.

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-08-11T01:34:59.91+00:00

    This error is typically caused by one of these conditions in the selected region:

    1. The subscription doesn’t currently have region access enabled for creating Azure SQL servers in West US 2.
    2. The subscription isn’t registered with the Microsoft.Sql resource provider.
    3. Regional capacity constraints are temporarily blocking deployments.

    Recommended path:

    1. In the Azure portal, open Subscriptions.
    2. Select the MCAPS-Hybrid-REQ- subscription.
    3. Go to Resource providers under Settings.
    4. Search for Microsoft.Sql.
    5. If it is not registered, select Register or Re-register.

    If the error message is one of these:

    • Your subscription does not have access to create a server in the selected region.
    • Provisioning is restricted in this region. Please choose a different region. For exceptions to this rule please open a support request with issue type of 'Service and subscription limits'
    • Location 'region name' is not accepting creation of new Windows Azure SQL Database servers for the subscription 'subscription id' at this time

    then file a support request to enable the region for the subscription.

    In the support request, use:

    • Issue type: Service and subscription limits (quotas)
    • Quota type: SQL database
    • Request type/details: Region access
    • Location: West US 2
    • Include the expected vCore requirement

    If deployment is still blocked after registration and the region-access request, the remaining cause is likely regional capacity limitation. In that case, either retry later or use another supported region temporarily.

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.