github.com/danp/terraform@v0.9.5-0.20170426144147-39d740081351/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  ~> **Note:** All arguments including the administrator login and password will be stored in the raw state as plain-text.
    14  [Read more about sensitive data in state](/docs/state/sensitive-data.html).
    15  
    16  ## Example Usage
    17  
    18  ```hcl
    19  resource "azurerm_resource_group" "test" {
    20    name     = "acceptanceTestResourceGroup1"
    21    location = "West US"
    22  }
    23  
    24  resource "azurerm_sql_server" "test" {
    25    name                         = "mysqlserver"
    26    resource_group_name          = "${azurerm_resource_group.test.name}"
    27    location                     = "West US"
    28    version                      = "12.0"
    29    administrator_login          = "mradministrator"
    30    administrator_login_password = "thisIsDog11"
    31  
    32    tags {
    33      environment = "production"
    34    }
    35  }
    36  ```
    37  ## Argument Reference
    38  
    39  The following arguments are supported:
    40  
    41  * `name` - (Required) The name of the SQL Server.
    42  
    43  * `resource_group_name` - (Required) The name of the resource group in which to
    44      create the sql server.
    45  
    46  * `location` - (Required) Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.
    47  
    48  * `version` - (Required) The version for the new server. Valid values are: 2.0 (for v11 server) and 12.0 (for v12 server).
    49  
    50  * `administrator_login` - (Required) The administrator login name for the new server.
    51  
    52  * `administrator_login_password` - (Required) The password for the new AdministratorLogin. Please following Azures [Password Policy](https://msdn.microsoft.com/library/ms161959.aspx)
    53  
    54  * `tags` - (Optional) A mapping of tags to assign to the resource.
    55  
    56  ## Attributes Reference
    57  
    58  The following attributes are exported:
    59  
    60  * `id` - The SQL Server ID.
    61  * `fully_qualified_domain_name` - The fully qualified domain name of the Azure SQL Server (e.g. myServerName.database.windows.net)
    62  
    63  ## Import
    64  
    65  SQL Servers can be imported using the `resource id`, e.g.
    66  
    67  ```
    68  terraform import azurerm_sql_server.test /subscriptions/00000000-0000-0000-0000-000000000000/resourceGroups/myresourcegroup/providers/Microsoft.Sql/servers/myserver
    69  ```