azurerm_sql_server: Enable SystemAssigned identity

[bgs113]

This provides the capability to enable "SystemAssigned" identity on SQL Server resources, as in the following:

resource "azurerm_sql_server" "test" {
  name                         = "mysqlserver"
  resource_group_name          = azurerm_resource_group.test.name
  location                     = "azurerm_resource_group.test.location"
  version                      = "12.0"
  administrator_login          = "mradministrator"
  administrator_login_password = "thisIsDog11"

  identity {
    type = "SystemAssigned"
  }

  tags = {
    environment = "production"
  }
}

This is a prerequisite to enabling SQL TDE with BYOK using Azure Key Vault (requested in #87)

[tombuildsstuff]

hey @bgs113

Thanks for this PR - taking a look through this is looking good - if we can fix up the minor comments (and the tests pass) then this otherwise LGTM 👍

Thanks!

[bgs113]

I updated the SQL Server data source to include the identity information. Let me know if you have any additional feedback or need anything else to move forward.

[tombuildsstuff]

Tests pass:

[tombuildsstuff]

hey @bgs113

Thanks for pushing those changes - taking a look through this LGTM 👍

Thanks!

[ghost]

This has been released in version 1.37.0 of the provider. Please see the Terraform documentation on provider versioning or reach out if you need any assistance upgrading. As an example:

provider "azurerm" {
    version = "~> 1.37.0"
}
# ... other configuration ...

[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!