Setting up SQL server and database I did not have option to choose location US (East)

@Linda Mitchell
Thank you for the question and for using Microsoft Q&A platform.

It seems like you're facing a subscription limitation issue, which is preventing you from creating a SQL Server in the US East region but allowing it in Australia East. This error typically occurs when specific regions have capacity constraints or are restricted based on the subscription type, such as free or trial subscriptions.

To resolve this, you can try the following approaches:

1. Check Region Availability

Visit the URL provided in the error message (aka.ms/sqlcapacity) to check the availability of SQL resources in different regions for your subscription. Some regions might have limited capacity for certain types of subscriptions, including free or trial plans.
https://zcusa.951200.xyz/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql&tabs=portal#subscription-access

2. Change to Another Region

If US East is not available for your subscription, you can try creating the SQL Server in a different region in the US, such as US Central or US West. This might bypass the issue while keeping the server geographically closer to your preferred location.

3. Request Access via Support

If you prefer to use US East but are blocked due to a subscription limit, you can request access to this region by submitting a support ticket.
https://zcusa.951200.xyz/en-us/azure/azure-sql/database/quota-increase-request?view=azuresql

You can also refer to the below links for more help:
https://zcusa.951200.xyz/en-us/answers/questions/740399/azure-wont-let-me-create-a-resource-in-my-local-re
https://zcusa.951200.xyz/en-us/answers/questions/1865647/unable-to-create-sql-server-getting-like-your-subs

Hope this helps. Do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.