Message="The name 'easqlserver.database.windows.net' already exists.

[lspeleman]

Hi,

I'm new to Terraform. I'm trying to create a sql server in Azure. My first steps. But I'm stuck and I don't understand what is giving me this error. The SQL Server does not exist. I guess the error is misleading me. But I have no idea how to debug to get more information in what went wrong.

If anyone has an idea, I will be grateful.

This is my main.tf

The provider

provider "azurerm" {

AzureRM provider 2.x

version = "~>2.0" subscription_id = "xxxxxxxxxxxxxxxxxxxxx"

v2.x required "features" block

features {} }

Create SQL Server

resource "azurerm_sql_server" "cld2paasgrpeasrvn002" { name = "easqlserver" resource_group_name = "RESOURCE_GRP_NAME" location = "West Europe" version = "12.0" administrator_login = "lucabc" administrator_login_password = "1-fdfd-dfd1"

tags = { environment = "testing" } }

This is the error I receive

luc@Azure:~/clouddrive/TERRAFORM-TEST-PLAN$ terraform apply

An execution plan has been generated and is shown below. Resource actions are indicated with the following symbols:

• create

Terraform will perform the following actions:

azurerm_sql_server.cld2paasgrpeasrvn002 will be created

• resource "azurerm_sql_server" "cld2paasgrpeasrvn002" {
  • administrator_login = "lucabc"
  • administrator_login_password = (sensitive value)
  • connection_policy = "Default"
  • fully_qualified_domain_name = (known after apply)
  • id = (known after apply)
  • location = "westeurope"
  • name = "easqlserver"
  • resource_group_name = "RESOURCE_GRP_NAME"
  • tags = {
    • "environment" = "testing" }
  • version = "12.0" }

Plan: 1 to add, 0 to change, 0 to destroy.

Do you want to perform these actions? Terraform will perform the actions described above. Only 'yes' will be accepted to approve.

Enter a value: yes

azurerm_sql_server.cld2paasgrpeasrvn002: Creating...

Error: Error waiting on create/update future for SQL Server "easqlserver" (Resource Group "RESOURCE_GRP_NAME"): Code="NameAlreadyExists" Message="The name 'easqlserver.database.windows.net' already exists. Choose a different name."

on main.tf line 11, in resource "azurerm_sql_server" "cld2paasgrpeasrvn002": 11: resource "azurerm_sql_server" "cld2paasgrpeasrvn002" {

luc@Azure:~/clouddrive/TERRAFORM-TEST-PLAN$

[ljluestc]

provider "azurerm" {
  version = "~>2.0"
  subscription_id = "xxxxxxxxxxxxxxxxxxxxx"
  features {}
}

resource "azurerm_sql_server" "cld2paasgrpeasrvn002" {
  name                = "mynewsqlserver"  # Choose a unique name here
  resource_group_name = "RESOURCE_GRP_NAME"
  location            = "West Europe"
  version             = "12.0"
  administrator_login = "lucabc"
  administrator_login_password = "1-fdfd-dfd1"

  tags = {
    environment = "testing"
  }
}