Skip to content

Think-Cube/terraform-azure-mssql-server

Repository files navigation

Requirements

Name Version
terraform >= 1.6.4
azurerm 3.100.0

Providers

Name Version
azurerm 3.100.0

Resources

Name Type
azurerm_mssql_firewall_rule.main resource
azurerm_mssql_server.main resource
azurerm_client_config.current data source
azurerm_resource_group.main data source

Inputs

Name Description Type Default Required
default_tags A mapping of tags to assign to the resource. map(any)
{
"ManagedByTerraform": "True"
}
no
environment Variable that defines the name of the environment. string "dev" no
mssql_server_admin_login The administrator login name for the new server. Required unless azuread_authentication_only in the azuread_administrator block is true. When omitted, Azure will generate a default username which cannot be subsequently changed. Changing this forces a new resource to be created. string n/a yes
mssql_server_admin_password The password associated with the administrator_login user. Needs to comply with Azure's Password Policy. Required unless azuread_authentication_only in the azuread_administrator block is true. string n/a yes
mssql_server_azure_ad_admin_login The login username of the Azure AD Administrator of this SQL Server. string n/a yes
mssql_server_azure_ad_admin_object_id The object id of the Azure AD Administrator of this SQL Server. string n/a yes
mssql_server_azure_tenant_id The tenant id of the Azure AD Administrator of this SQL Server. string n/a yes
mssql_server_connection_policy The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default. string "Default" no
mssql_server_ip_rules Map of IP addresses permitted for access to DB map(string) {} no
mssql_server_minimum_tls_version The Minimum TLS Version for all SQL Database and SQL Data Warehouse databases associated with the server. Valid values are: 1.0, 1.1 , 1.2 and Disabled. Defaults to 1.2. string "1.2" no
mssql_server_name The name of the Microsoft SQL Server. This needs to be globally unique within Azure. Changing this forces a new resource to be created. string n/a yes
mssql_server_public_network_access_enabled Whether public network access is allowed for this server. Defaults to true. bool true no
mssql_server_version The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server). Changing this forces a new resource to be created. string 12 no
region Region in which resources are deployed. string "weu" no
resource_group_location Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created. string "West Europe" no
resource_group_name The name of the resource group in which to create the Microsoft SQL Server. Changing this forces a new resource to be created. string n/a yes

Outputs

Name Description
fqdn The fully qualified domain name of the Azure SQL Server
id the Microsoft SQL Server ID.
identity Identity properties assigned to Azure SQL Server
name Azure SQL Server Name