This message was deleted.
# general
b
This message was deleted.
l
Hi @few-father-18060. Are you able to provide an example of the terraform code that creates this resource?
f
# Create storage account for boot diagnostics resource "azurerm_storage_account" "mystorageaccountH90SV30601505DB" { name = "diag${random_id.randomId.hex}" location = azurerm_resource_group.rg.location resource_group_name = azurerm_resource_group.rg.name account_tier = "Standard" account_replication_type = "LRS" } resource "azurerm_network_interface" "nicH90SV30601505DB" { name = "example-nic" location = azurerm_resource_group.rg.location resource_group_name = azurerm_resource_group.rg.name ip_configuration { name = "internal" subnet_id = azurerm_subnet.myterraformsubnet.id private_ip_address_allocation = "Dynamic" } } # Create virtual machine resource "azurerm_windows_virtual_machine" "H90SV30601505DB" { name = "H90SV30601505DB" size = "E32-16s_v5" location = azurerm_resource_group.rg.location resource_group_name = azurerm_resource_group.rg.name admin_username = "adminuser" admin_password = "P@$$w0rd1234!" network_interface_ids = [azurerm_network_interface.nicH90SV30601505DB.id] os_disk { name = "myOsDisk" caching = "ReadWrite" storage_account_type = "Premium_LRS" } source_image_reference { publisher = "MicrosoftSQLServer" offer = "sql2019-ws2019" sku = "enterprise" version = "latest" } boot_diagnostics { storage_account_uri = azurerm_storage_account.mystorageaccountH90SV30601505DB.primary_blob_endpoint } } resource "azurerm_managed_disk" "managed_diskH90SV30601505DB" { name = "managed${random_id.randomId.hex}" location = azurerm_resource_group.rg.location resource_group_name = azurerm_resource_group.rg.name storage_account_type = "Premium_LRS" create_option = "Empty" disk_size_gb = 4096 } resource "azurerm_virtual_machine_data_disk_attachment" "managed_disk_attachH90SV30601505DB" { managed_disk_id = azurerm_managed_disk.managed_diskH90SV30601505DB.id virtual_machine_id = azurerm_windows_virtual_machine.H90SV30601505DB.id lun = "10" caching = "ReadWrite" } resource "azurerm_mssql_virtual_machine" "sqlH90SV30601505DB" { virtual_machine_id = azurerm_windows_virtual_machine.H90SV30601505DB.id sql_license_type = "PAYG" r_services_enabled = true sql_connectivity_port = 1433 sql_connectivity_type = "PRIVATE" sql_connectivity_update_password = "Password1234!" sql_connectivity_update_username = "sqllogin" auto_patching { day_of_week = "Sunday" maintenance_window_duration_in_minutes = 60 maintenance_window_starting_hour = 2 } }
l
@few-father-18060 thanks 🙏. It seems we don’t yet support the
azurerm_mssql_virtual_machine
resource. You can see a list of the supported resources here, or if you run Infracost with
--show-skipped
you can see which resources aren’t supported from your run. Here’s some info on how to request a resource.
f
Thank you @little-author-61621
l
No problem simple smile