avm-res-sql-server
Azure/avm-res-sql-server/azurerm
Terraform Azure Verified Resource Module for Azure SQL Server
terraform-azurerm-avm-sql-server This is a resource module repo for SQL Server on Azure. > [!WARNING] > Major version Zero (0.y.z) is for initial development. Anything MAY change at any time. A module SHOULD NOT be considered stable till at least it is major version one (1.0.0) or greater. Changes will always be via new versions being published and no changes will be made to existing published versions. For more details please go to Requirements The following requirements are needed by this module: - terraform (>= 1.9, azapi (~> 2.4) - azurerm (~> 4.26) - modtm (~> 0.3) - random (~> 3.6) Resources The following resources are used by this module: - azurerm_management_lock.this (resource) - azurerm_monitor_diagnostic_setting.this (resource) - azurerm_mssql_firewall_rule.this (resource) - azu
| Name | Type | Description | Default |
|---|---|---|---|
| location | string | Azure region where the resource should be deployed. If null, the location will | required |
| resource_group_name | string | The resource group where the resources will be deployed. | required |
| server_version | string | (Required) The version for the new server. Valid values are: 2.0 (for v11 server | required |
| administrator_login | string | (Optional) The administrator login name for the new server. Required unless `azu | null |
| administrator_login_password | string | (Optional) The password associated with the `administrator_login` user. Needs to | null |
| administrator_login_password_wo_version | number | (Optional) The version of the write-only password. This is used in conjunction w | null |
| azuread_administrator | object({ azuread_authentic | - `azuread_authentication_only` - (Optional) Specifies whether only AD Users and | null |
| express_vulnerability_assessment_enabled | bool | (Optional) Whether the `Express Vulnerability Assessment` feature is enabled for | false |
| primary_user_assigned_identity_id | string | (Optional) Specifies the primary user managed identity id. Required if `type` wi | null |
| transparent_data_encryption_key_vault_key_id | string | (Optional) The fully versioned `Key Vault` `Key` URL (e.g. `'https://<YourVaultN | null |
| diagnostic_settings | map(object({ name | A map of diagnostic settings to create on the Key Vault. The map key is delibe | {} |
| databases | map(object({ name | A map of objects used to describe any databases that are being created. The map | {} |
| administrator_login_password_wo | string | (Optional) The password associated with the `administrator_login` user (write-on | null |
| outbound_network_restriction_enabled | bool | (Optional) Whether outbound network traffic is restricted for this server. Defau | null |
| enable_telemetry | bool | This variable controls whether or not telemetry is enabled for the module. For m | true |
| private_endpoints | map(object({ name = option | A map of private endpoints to create on the Key Vault. The map key is delibera | {} |
| role_assignments | map(object({ role_definiti | A map of role assignments to create on the <RESOURCE>. The map key is delibera | {} |
| public_network_access_enabled | bool | (Optional) Whether public network access is allowed for this server. Defaults to | false |
| elastic_pools | map(object({ name = st | A map of objects containing attributes for each Elastic Pool to be created. - ` | {} |
| firewall_rules | map(object({ end_ip_addres | - `end_ip_address` - (Required) Specifies the End IP Address associated with thi | {} |
| managed_identities | object({ system_assigned | Controls the Managed Identity configuration on this resource. The following pr | {} |
| private_endpoints_manage_dns_zone_group | bool | Whether to manage private DNS zone groups with this module. If set to false, you | true |
| tags | map(string) | (Optional) Tags of the resource. | null |
private_endpoints — A map of the private endpoints created.
resource — This is the full output for the resource.resource_databases — A map of databases. The map key is the supplied input to var.databases. The map value is the entire resource_elasticpools — A map of elastic pools. The map key is the supplied input to var.elastic_pools. The map value is theresource_id — This is the id of the resource.resource_name — This is the name of the resource.