0

In my resource group I am trying to turn on auto-tuning via our ARM Template using this bit of JSON. What we'd like to know is, is if that restriction on PUT is from Org Policy and not just the fact that Azure(MS) does not allow us to turn on that functionality using an ARM Template.

When this is ran we are getting the following error:

{
    "code":"MethodNotAllowed",
    "message":"The HTTP method 'PUT' is not supported on the resource."
}

I am trying to turn on auto-tuning via our ARM Template

{
    "type": "Microsoft.Sql/servers/databases/automaticTuning",
    "apiVersion": "2020-11-01-preview",
    "dependsOn": [
        "[resourceId('Microsoft.Sql/servers/databases', parameters('sqlServerName'), parameters('dbName'))]"
    ],
    "name": "[concat(parameters('sqlServerName'), '/', parameters('dbName'), '/current')]",
    "properties": {
        "options": {
            "ForceLastGoodPlan": {
                "desiredState": "[parameters('forceLastGoodPlanState')]"
            },
            "CreateIndex": {
                "desiredState": "[parameters('createIndexState')]"
            },
            "DropIndex": {
                "desiredState": "[parameters('dropIndexState')]"
            }
        }
    }
}
Improve this question
3
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. Commented Sep 19 at 15:27
  • What is auto-tuning? Is this something that you have developed yourself? Commented Sep 23 at 7:12
  • I am trying to configure Automatic tuning for my SQL database, however I am getting this error {"code":"MethodNotAllowed","message":"The HTTP method 'PUT' is not supported on the resource 'subscriptions/b72849a9-3d1j-678b-0975-28sj9rg369d9/resourcegroups/MyDev-RG/providers/Microsoft.Sql/servers/mysql-dev/databases/mysqldevdb/automaticTuning/current'."}. I just want to know if this is something blocked due to any of my policy or soemthing Azure does not allow us to turn on this functionality using an ARM Template for SQL database. Commented Sep 23 at 12:49
Related questions
1
Alert rule in Azure ARM template not enabled in web test
7
Azure Resource Manager Template Language - resourceId(): Unable to evaluate template language function 'resource Id'
0
Unable to create multiple databases with the same name on different SQL Servers in Azure via ARM templates
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.