github.com/vtorhonen/terraform@v0.9.0-beta2.0.20170307220345-5d894e4ffda7/website/source/docs/providers/azurerm/r/sql_server.html.markdown (about) 1 --- 2 layout: "azurerm" 3 page_title: "Azure Resource Manager: azurerm_sql_server" 4 sidebar_current: "docs-azurerm-resource-sql-server" 5 description: |- 6 Create a SQL Server. 7 --- 8 9 # azurerm\_sql\_server 10 11 Allows you to manage an Azure SQL Database Server 12 13 ## Example Usage 14 15 ``` 16 resource "azurerm_resource_group" "test" { 17 name = "acceptanceTestResourceGroup1" 18 location = "West US" 19 } 20 21 resource "azurerm_sql_server" "test" { 22 name = "mysqlserver" 23 resource_group_name = "${azurerm_resource_group.test.name}" 24 location = "West US" 25 version = "12.0" 26 administrator_login = "mradministrator" 27 administrator_login_password = "thisIsDog11" 28 29 tags { 30 environment = "production" 31 } 32 } 33 ``` 34 ## Argument Reference 35 36 The following arguments are supported: 37 38 * `name` - (Required) The name of the SQL Server. 39 40 * `resource_group_name` - (Required) The name of the resource group in which to 41 create the sql server. 42 43 * `location` - (Required) Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created. 44 45 * `version` - (Required) The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server). 46 47 * `administrator_login` - (Required) The administrator login name for the new server. 48 49 * `administrator_login_password` - (Required) The password for the new AdministratorLogin. Please following Azures [Password Policy](https://msdn.microsoft.com/library/ms161959.aspx) 50 51 * `tags` - (Optional) A mapping of tags to assign to the resource. 52 53 ## Attributes Reference 54 55 The following attributes are exported: 56 57 * `id` - The SQL Server ID. 58 * `fully_qualified_domain_name` - The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net) 59 60 ## Import 61 62 SQL Servers can be imported using the `resource id`, e.g. 63 64 ``` 65 terraform import azurerm_sql_server.test /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver 66 ```