az_mssql.tf

provider "azurerm" {
  features {}
}

resource "azurerm_resource_group" "az_rg" {
  name     = "example-resources"
  location = "West Europe"
}

resource "azurerm_mssql_server" "mssql1" {
  name                         = "mssql1" 
  resource_group_name          = azurerm_resource_group.az_rg.name
  location                     = azurerm_resource_group.az_rg.location
  version                      = "12.0"
  administrator_login          = "missadministrator"
  administrator_login_password = "AdminPassword123!"

  extended_auditing_policy {
    storage_endpoint                        = azurerm_storage_account.sa1.primary_blob_endpoint
    storage_account_access_key              = azurerm_storage_account.sa1.primary_access_key
    storage_account_access_key_is_secondary = false
    retention_in_days                       = 180
  }
}

resource "azurerm_storage_account" "sa1" {
  name                     = "sa1"
  resource_group_name      = azurerm_resource_group.az_rg.name
  location                 = azurerm_resource_group.az_rg.location
  account_tier             = "Standard"
  account_replication_type = "LRS"
  enable_https_traffic_only = true
}

resource "azurerm_mssql_server" "mssql2" {
  name                         = "mssql2"
  resource_group_name          = azurerm_resource_group.az_rg.name
  location                     = azurerm_resource_group.az_rg.location
  version                      = "12.0"
  administrator_login          = "missadministrator"
  administrator_login_password = "AdminPassword123!"

  extended_auditing_policy {
    storage_endpoint                        = azurerm_storage_account.sa2.primary_blob_endpoint
    storage_account_access_key              = azurerm_storage_account.sa2.primary_access_key
    storage_account_access_key_is_secondary = false
    retention_in_days                       = 180
  }
}

resource "azurerm_storage_account" "sa2" {
  name                     = "sa2"
  resource_group_name      = azurerm_resource_group.az_rg.name
  location                 = azurerm_resource_group.az_rg.location
  account_tier             = "Standard"
  account_replication_type = "LRS"
  enable_https_traffic_only = true
}

resource "azurerm_mssql_server" "mssql3" {
  name                         = "mssql3"
  resource_group_name          = azurerm_resource_group.az_rg.name
  location                     = azurerm_resource_group.az_rg.location
  version                      = "12.0"
  administrator_login          = "missadministrator"
  administrator_login_password = "AdminPassword123!"

  extended_auditing_policy {
    storage_endpoint                        = azurerm_storage_account.sa3.primary_blob_endpoint
    storage_account_access_key              = azurerm_storage_account.sa3.primary_access_key
    storage_account_access_key_is_secondary = false
    retention_in_days                       = 180
  }
}

resource "azurerm_storage_account" "sa3" {
  name                     = "sa3"
  resource_group_name      = azurerm_resource_group.az_rg.name
  location                 = azurerm_resource_group.az_rg.location
  account_tier             = "Standard"
  account_replication_type = "LRS"
  enable_https_traffic_only = true
}

resource "azurerm_mssql_server" "mssql4" {
  name                         = "mssql4"
  resource_group_name          = azurerm_resource_group.az_rg.name
  location                     = azurerm_resource_group.az_rg.location
  version                      = "12.0"
  administrator_login          = "missadministrator"
  administrator_login_password = "AdminPassword123!"

  extended_auditing_policy {
    storage_endpoint                        = azurerm_storage_account.sa4.primary_blob_endpoint
    storage_account_access_key              = azurerm_storage_account.sa4.primary_access_key
    storage_account_access_key_is_secondary = false
    retention_in_days                       = 180
  }
}

resource "azurerm_storage_account" "sa4" {
  name                     = "sa4"
  resource_group_name      = azurerm_resource_group.az_rg.name
  location                 = azurerm_resource_group.az_rg.location
  account_tier             = "Standard"
  account_replication_type = "LRS"
  enable_https_traffic_only = true
}

resource "azurerm_mssql_server" "mssql5" {
  name                         = "mssql5" 
  resource_group_name          = azurerm_resource_group.az_rg.name
  location                     = azurerm_resource_group.az_rg.location
  version                      = "12.0"
  administrator_login          = "missadministrator"
  administrator_login_password = "AdminPassword123!"

  extended_auditing_policy {
    storage_endpoint                        = azurerm_storage_account.sa5.primary_blob_endpoint
    storage_account_access_key              = azurerm_storage_account.sa5.primary_access_key
    storage_account_access_key_is_secondary = false
    retention_in_days                       = 7
  }
}

resource "azurerm_storage_account" "sa5" {
  name                     = "sa5"
  resource_group_name      = azurerm_resource_group.az_rg.name
  location                 = azurerm_resource_group.az_rg.location
  account_tier             = "Standard"
  account_replication_type = "LRS"
  enable_https_traffic_only = true
}