Skip to content

QuestOpsHub/terraform-azurerm-mssql-server

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Requirements

Name Version
terraform >=0.13
azurerm >=4.0.0

Providers

Name Version
azurerm >=4.0.0

Modules

No modules.

Resources

Name Type
azurerm_mssql_server.mssql_server resource
azurerm_client_config.current data source

Inputs

Name Description Type Default Required
administrator_login (Optional) 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 null no
administrator_login_password (Optional) The password associated with the administrator_login user. string null no
azuread_administrator (Optional) An azuread_administrator block any {} no
connection_policy (Optional) The connection policy the server will use. Possible values are Default, Proxy, and Redirect. Defaults to Default. string "Default" no
identity (Optional) An identity block any {} no
location (Required) Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created. string n/a yes
minimum_tls_version (Optional) 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_version (Required) 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 n/a yes
name (Required) 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
outbound_network_restriction_enabled (Optional) Whether outbound network traffic is restricted for this server. Defaults to false. bool false no
primary_user_assigned_identity_id (Optional) Specifies the primary user managed identity id. Required if type within the identity block is set to either SystemAssigned, UserAssigned or UserAssigned and should be set at same time as setting identity_ids. string null no
public_network_access_enabled (Optional) Whether public network access is allowed for this server. Defaults to true. bool true no
resource_group_name (Required) 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
tags (Optional) A mapping of tags to assign to the resource. map(any) {} no
transparent_data_encryption_key_vault_key_id (Optional) The fully versioned Key Vault Key URL (e.g. 'https://.vault.azure.net/keys//) to be used as the Customer Managed Key(CMK/BYOK) for the Transparent Data Encryption(TDE) layer. string null no

Outputs

Name Description
fully_qualified_domain_name The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
id Microsoft SQL Server ID.
name Microsoft SQL Server Name.
restorable_dropped_database_ids A list of dropped restorable database IDs on the server.

Packages

 
 
 

Contributors

Languages