df_ssmi/sqlmi.tf at master · 2mOlaf/df_ssmi · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
resource "azurerm_subnet" "sqlmi-subnet" {
  name                 = "${var.DeploymentLifecycle}-${var.AppName}-${var.LOB}-sqlmisubnet"
  resource_group_name  = "${azurerm_resource_group.pdw-rg.name}"
  virtual_network_name = "${azurerm_virtual_network.pdw-vnet.name}"
  address_prefix       = "${cidrsubnet(var.vnet2_address, 2, 1)}"
  #service_endpoints    = ["Microsoft.Sql"]
}

resource "azurerm_network_security_group" "sqlmi" {
  name = "${var.DeploymentLifecycle}-${var.AppName}-${var.LOB}-sqlminsg"
  location = "${var.azure_region}"
  resource_group_name = "${azurerm_resource_group.pdw-rg.name}"

  security_rule {
    name                       = "rdp"
    priority                   = 300
    direction                  = "Inbound"
    access                     = "Allow"
    protocol                   = "Tcp"
    source_port_range          = "*"
    destination_port_range    = "3389"
    source_address_prefix      = "*"
    destination_address_prefix = "*"

  }

  tags {
    environment = "${var.DeploymentLifecycle}"
  }
}

resource "azurerm_route_table" "default" {
  name                = "${var.DeploymentLifecycle}-${var.AppName}-${var.LOB}-rtdefault"
  resource_group_name = "${azurerm_resource_group.pdw-rg.name}"
  location            = "${var.azure_region}"
  disable_bgp_route_propagation = false

  route {
    name           = "internet"
    address_prefix = "0.0.0.0/0"
    next_hop_type  = "Internet"
  }

  tags {
    environment = "${var.DeploymentLifecycle}-${var.AppName}-${var.LOB}"
  }
}

resource "azurerm_subnet_route_table_association" "sql-mi" {
  subnet_id      = "${azurerm_subnet.sqlmi-subnet.id}"
  route_table_id = "${azurerm_route_table.default.id}"
}

resource "azurerm_subnet_network_security_group_association" "sqlmi" {
  subnet_id                 = "${azurerm_subnet.sqlmi-subnet.id}"
  network_security_group_id = "${azurerm_network_security_group.sqlmi.id}"
}

resource "azurerm_public_ip" "sql-mi-ip" {
  name                = "SQLMI-${var.sql_mi_name}-Gate-IP"
  resource_group_name = "${azurerm_resource_group.pdw-rg.name}"
  location            = "${var.azure_region}"
  allocation_method   = "Dynamic"
  sku                 ="basic"
  tags {
    environment = "${var.DeploymentLifecycle}-${var.AppName}-${var.LOB}"
  }
}