Error Creating Basic Edition SQL Database

[eoly]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform Version

Terraform v0.11.8

• provider.azurerm v1.15.0

Affected Resource(s)

• azurerm_sql_database

Terraform Configuration Files

resource "azurerm_resource_group" "mod" {
  name     = "test"
  location = "centralus"
}

resource "azurerm_sql_server" "test" {
  name                = "test20180914"
  location            = "centralus"
  resource_group_name = "${azurerm_resource_group.mod.name}"

  administrator_login          = "localtest"
  administrator_login_password = "**********"

  version = "12.0"
}


resource "azurerm_sql_database" "test" {
  name                = "test"
  location            = "centralus"
  resource_group_name = "${azurerm_resource_group.mod.name}"

  server_name    = "${azurerm_sql_server.test.name}"
  create_mode    = "Default"
  edition        = "Basic"

  requested_service_objective_name = "S0"
}

Expected Behavior

Basic Edition Azure SQL Database created

Actual Behavior

azurerm_sql_database.test: Creating...
  collation:                        "" => "<computed>"
  create_mode:                      "" => "Default"
  creation_date:                    "" => "<computed>"
  default_secondary_location:       "" => "<computed>"
  edition:                          "" => "Basic"
  elastic_pool_name:                "" => "<computed>"
  encryption:                       "" => "<computed>"
  location:                         "" => "centralus"
  max_size_bytes:                   "" => "<computed>"
  name:                             "" => "test"
  requested_service_objective_id:   "" => "<computed>"
  requested_service_objective_name: "" => "S0"
  resource_group_name:              "" => "test"
  restore_point_in_time:            "" => "<computed>"
  server_name:                      "" => "test20180914"
  source_database_deletion_date:    "" => "<computed>"
  source_database_id:               "" => "<computed>"
  tags.%:                           "" => "<computed>"
  threat_detection_policy.#:        "" => "<computed>"

Error: Error applying plan:

1 error(s) occurred:

* azurerm_sql_database.test: 1 error(s) occurred:

* azurerm_sql_database.test: sql.DatabasesClient#CreateOrUpdate: Failure sending request: StatusCode=0 -- Original Error: json: cannot unmarshal array into Go struct field serviceError2.details of type map[string]interface {}

Steps to Reproduce

1. terraform apply

References

• terraform throws error while creating premium tier elasticpool : azurerm_sql_elasticpool #1605

[WodansSon]

This is hitting the exact same issue as #1605 , the message you are getting back is actually:

{
  "code": "40808",
  "message": "The edition \u0027Basic\u0027 does not support the service objective \u0027S0\u0027.",
  "target": null,
  "details": [
    {
      "code": "40808",
      "message": "The edition \u0027Basic\u0027 does not support the service objective \u0027S0\u0027.",
      "target": null,
      "severity": "16"
    }
  ],
  "innererror": []
}

[tombuildsstuff]

Closing this in favour of #1605 since this is the same issue

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. If you feel I made an error 🤖 🙉 , please reach out to my human friends 👉 [email protected]. Thanks!