sql server

# Set the Azure Provider source and version being used
terraform {
  required_version = ">= 0.14"

  required_providers {
    azurerm = {
      source  = "hashicorp/azurerm"
      version = "~> 3.1.0"
    }
  }
}

# Configure the Microsoft Azure provider
provider "azurerm" {
  features {}
}

terraform {
  backend "azurerm" {
    resource_group_name      = "rgteswesteu001"
    storage_account_name     = "strgtestwesteu001"
    container_name           = "conttesywesteu001"
    key                      = "terraform.tfstate"
  }
}
# create Resource Group 
data "azurerm_resource_group" "resourcegroup" {
  name     = "rgteswesteu001"
}

# create sql server
resource "azurerm_sql_server" "test" {
    name                            = "sqltestwesteu001"
    resource_group_name             = "rgtestwesteu009"
    location                        = "West Europe"
    version                         = "12.0"
    administrator_login             = "adm1234"
    administrator_login_password    = "Adm@123456789"
     tags = {
         environment = "test"
     }
}

#create storage account
resource "azurerm_storage_account" "test" {
    name                        = "strgtestwesteu009"
    resource_group_name         = "rgtestwesteu001"
    location                    = "West Europe"
    account_tier                = "Standard"
    account_replication_type    = "LRS"
}

#create sql database
resource "azurerm_sql_database" "test" {
    name                    = "sqldbtestwesteu009"
    resource_group_name     = "rgtestwesteu001"
    location                = "West Europe"
    server_name             = azurerm_sql_server.test.name

    tags = {
        environment = "test"
    }

}