Hi Ricky,
Please carefully follow my instructions below to create a new Service and subscription limits (quotas) request to allow access to SQL Zone redundancy for the subscription/region you need.
1. Navigate to this link to start the process:
https://portal.azure.com/#view/Microsoft_Azure_Support/HelpAndSupportBlade/~/overview
2. Click Create a support request button at top
3. If you see Support AI Assistant as shown below, click Switch to old experience button on right. If not, proceed to step #4
4. Enter subscription limit in the box and click Go
5. Click Create a support request button, as shown
6. Select Issue type: Service and subscription limits (quotas), Subscription: <subscription where you need SQL zone redundancy, Quota type: SQL database, click Next
7. Now you should be on Additional details tab. Click Enter details
8. Select Zone Redundant Access (Availability Zones), select Location you need, enter number of cores, enter additional details in description box, click Save and continue
9. Finish filling out Additional details tab, click Next, review and click Create. You should receive an automated email within a few minutes.
Please click Accept Answer and upvote if the above was helpful.
Thanks.
-TP