think-cube / terraform-azure-mssql-server

Terraform module for Azure MSSQL server.

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

terraform-azure-mssql-server's Issues

Fix code scanning alert - Ensure databases are not publicly accessible

Tracking issue for:

• https://github.com/Think-Cube/terraform-azure-mssql-server/security/code-scanning/2

Fix code scanning alert - Auditing should be enabled on Azure SQL Databases

Tracking issue for:

• https://github.com/Think-Cube/terraform-azure-mssql-server/security/code-scanning/1