Unable to set SQL Managed Instance's Maintenance Window

Question

Hi everyone,

I have a SQL managed instance with default maintenance window "/subscriptions/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_Default"

However according the requirements, I need to change the default maintenance window to other window, and according to following document, it is possible, but it is not working for me when I tried to change it.

Tried with
"/subscriptions/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_CanadaCentral_MI_1"
and
"/subscriptions/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_CanadaCentral_MI_2"

Both got following errors:

"status": "Failed",
"error": {
"code": "ProvisioningDisabled",
"message": "Maintenance windows are not available in this region."

Tried to query the available maintenance windows for my region "canadacentral", and it shows these two are available:

az maintenance public-configuration list --query "[?location=='canadacentral'&&contains(maintenanceScope,'SQLManagedInstance')]"

[
{
"duration": "08:00",
"expirationDateTime": null,
"extensionProperties": {
"description": "10:00 PM to 6:00 AM Eastern Standard Time, Monday to Thursday"
},
"id": "/subscriptions/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_CanadaCentral_MI_1",
"location": "canadacentral",
"maintenanceScope": "SQLManagedInstance",
"name": "SQL_CanadaCentral_MI_1",
"namespace": null,
"recurEvery": "week Monday, Tuesday, Wednesday, Thursday",
"startDateTime": "2021-02-15 22:00",
"systemData": null,
"tags": {},
"timeZone": "Eastern Standard Time",
"type": "Microsoft.Maintenance/publicMaintenanceConfigurations",
"visibility": "Public"
},
{
"duration": "08:00",
"expirationDateTime": null,
"extensionProperties": {
"description": "10:00 PM to 6:00 AM Eastern Standard Time, Friday to Sunday"
},
"id": "/subscriptions/providers/Microsoft.Maintenance/publicMaintenanceConfigurations/SQL_CanadaCentral_MI_2",
"location": "canadacentral",
"maintenanceScope": "SQLManagedInstance",
"name": "SQL_CanadaCentral_MI_2",
"namespace": null,
"recurEvery": "week Friday, Saturday, Sunday",
"startDateTime": "2021-02-15 22:00",
"systemData": null,
"tags": {},
"timeZone": "Eastern Standard Time",
"type": "Microsoft.Maintenance/publicMaintenanceConfigurations",
"visibility": "Public"
}
]

So my guess is that they are indeed available, but the provisioning is disabled, need to request support in order to enable this feature?

Help is appreciated, thanks.

Jian

Answer 1

@Qi-Jian-Huang-DevOps We reviewed your subscription details internally and it is indeed an MSDN subscription.

Currently MSDN subscriptions are not eligible for preview features.
You can configure the maintenance window once the feature is generally available (GA).

However, we are fixing the error "Maintenance windows are not available in this region" with a more relevant message.
Thank you for taking the time to report this issue and contributing towards making our products better.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.