SQL Server

Overview

{
	"sql_server": {
		"name": "sql-lp-test-{env}",
		"keyvault": {
			"name": "kv-lp-test-{env}"
		},
        {
        "admin": {
			"username": "test1234",
			"password": "password1234"
		},

		"@log_analytics_workspace_name": "log-lp-test-{env}",
		"public_access": true,
		"version": "12.0",
		"firewall_rules": [
			{
				"name": "UserA House",
				"ip_address": "8.8.8.8"
			}
		],
		"vnet_config": {
			"@vnet_name": "vnet-lp-test-{env}",
			"@subnet_name": "sqlsub"
		},

		"location": "northeurope",
		"external": false,
		"resource_group_name": "my-rg-name",
    "tags": { "example": "S0" }
		}
	}
}

SQLServer Reference

Key	Type	Description
`name` (required)	string	The name of the SQL Server (see how to name)
`admin` (required)	Admin Definition	The admin account configuration
`keyvault` (required)	KeyVault Definition	The Key Vault configuration
`@log_analytics_workspace_name`	string	The name of the log analytics workspace to bind to (defaults to no log integration)
`public_access`	bool	Whether the SQL Server has pulbic access enabled or not (defaults to `false`)
`version`	string	The SQL version to use (defaults `12.0`)
`firewall_rules`	array of optionalFirewall Rules	The firewall rules to be added to the SQL Server
`vnet_config`	Vnet configuration	The configuration of the virtual network (Defaults to no vnet integration)
`location`	string	Resource Location (defaults to the resource group location)
`external`	bool	A reference to an existing SQL Server (defaults to `false`)
`resource_group_name`	string	The name of the resource group where the resource is located, only with external resources (defaults to the resource group of the deployment)
`tags`	object	Additional tags for the resource (defaults to no additional tags)

Admin Configuration

Key	Type	Description
`username` (required)	string	The Key Vault secret name that contains the desired admin username
`password` (required)	string	The Key Vault secret name that contains the desired admin password

Key Vault Configuration

Key	Type	Description
`name` (required)	string	The name of the Key Vault to bind to

FirewallRules

Key	Type	Description
`name`	string	The name of the firewall rule to be added
`ip_address`	string	The IP address to be added to the rule

VnetConfig

Key	Type	Description
`@vnet_name`	string	The name of the vnet to bind to
`@subnet_name`	string	The name of the subnet inside the vnet to use

Back

SQL Elastic Pool

Storage Account