{
  "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Resources/deployments/CreateVm-microsoftsqlserver.sql2019-ws2019-sqldev-20220824223219",
  "name": "CreateVm-microsoftsqlserver.sql2019-ws2019-sqldev-20220824223219",
  "type": "Microsoft.Resources/deployments",
  "tags": {
    "primaryResourceId": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourcegroups/Udemy/providers/Microsoft.Compute/virtualMachines/UdemyCourseonP",
    "marketplaceItemId": "Microsoft.VirtualMachine",
    "provisioningHash": "SolutionProvider"
  },
  "properties": {
    "templateHash": "8850928843228760288",
    "parameters": {
      "location": {
        "type": "String",
        "value": "westeurope"
      },
      "networkInterfaceName": {
        "type": "String",
        "value": "udemycourseonp527"
      },
      "networkSecurityGroupName": {
        "type": "String",
        "value": "UdemyCourseonP-nsg"
      },
      "networkSecurityGroupRules": {
        "type": "Array",
        "value": [
          {
            "name": "RDP",
            "properties": {
              "priority": 300,
              "protocol": "TCP",
              "access": "Allow",
              "direction": "Inbound",
              "sourceAddressPrefix": "*",
              "sourcePortRange": "*",
              "destinationAddressPrefix": "*",
              "destinationPortRange": "3389"
            }
          },
          {
            "name": "default-allow-sql",
            "properties": {
              "priority": 1600,
              "protocol": "TCP",
              "access": "Allow",
              "direction": "Inbound",
              "sourceAddressPrefix": "*",
              "sourcePortRange": "*",
              "destinationAddressPrefix": "*",
              "destinationPortRange": "1433"
            }
          }
        ]
      },
      "subnetName": {
        "type": "String",
        "value": "default"
      },
      "virtualNetworkName": {
        "type": "String",
        "value": "Udemy-vnet"
      },
      "addressPrefixes": {
        "type": "Array",
        "value": [
          "10.0.0.0/16"
        ]
      },
      "subnets": {
        "type": "Array",
        "value": [
          {
            "name": "default",
            "properties": {
              "addressPrefix": "10.0.0.0/24"
            }
          }
        ]
      },
      "publicIpAddressName": {
        "type": "String",
        "value": "UdemyCourseonP-ip"
      },
      "publicIpAddressType": {
        "type": "String",
        "value": "Static"
      },
      "publicIpAddressSku": {
        "type": "String",
        "value": "Standard"
      },
      "pipDeleteOption": {
        "type": "String",
        "value": "Delete"
      },
      "virtualMachineName": {
        "type": "String",
        "value": "UdemyCourseonP"
      },
      "virtualMachineComputerName": {
        "type": "String",
        "value": "UdemyCourseonP"
      },
      "virtualMachineRG": {
        "type": "String",
        "value": "Udemy"
      },
      "osDiskType": {
        "type": "String",
        "value": "Standard_LRS"
      },
      "osDiskDeleteOption": {
        "type": "String",
        "value": "Delete"
      },
      "dataDisks": {
        "type": "Array",
        "value": [
          {
            "lun": 0,
            "createOption": "attach",
            "deleteOption": "Detach",
            "caching": "ReadOnly",
            "writeAcceleratorEnabled": false,
            "id": null,
            "name": "UdemyCourseonP_DataDisk_0",
            "storageAccountType": null,
            "diskSizeGB": null,
            "diskEncryptionSet": null
          },
          {
            "lun": 1,
            "createOption": "attach",
            "deleteOption": "Detach",
            "caching": "None",
            "writeAcceleratorEnabled": false,
            "id": null,
            "name": "UdemyCourseonP_DataDisk_1",
            "storageAccountType": null,
            "diskSizeGB": null,
            "diskEncryptionSet": null
          }
        ]
      },
      "dataDiskResources": {
        "type": "Array",
        "value": [
          {
            "name": "UdemyCourseonP_DataDisk_0",
            "sku": "Premium_LRS",
            "properties": {
              "diskSizeGB": 8,
              "creationData": {
                "createOption": "empty"
              }
            }
          },
          {
            "name": "UdemyCourseonP_DataDisk_1",
            "sku": "Premium_LRS",
            "properties": {
              "diskSizeGB": 8,
              "creationData": {
                "createOption": "empty"
              }
            }
          }
        ]
      },
      "virtualMachineSize": {
        "type": "String",
        "value": "Standard_B1s"
      },
      "nicDeleteOption": {
        "type": "String",
        "value": "Delete"
      },
      "adminUsername": {
        "type": "String",
        "value": "kamval"
      },
      "adminPassword": {
        "type": "SecureString"
      },
      "patchMode": {
        "type": "String",
        "value": "AutomaticByOS"
      },
      "enableHotpatching": {
        "type": "Bool",
        "value": false
      },
      "autoShutdownStatus": {
        "type": "String",
        "value": "Enabled"
      },
      "autoShutdownTime": {
        "type": "String",
        "value": "19:00"
      },
      "autoShutdownTimeZone": {
        "type": "String",
        "value": "W. Europe Standard Time"
      },
      "autoShutdownNotificationStatus": {
        "type": "String",
        "value": "Enabled"
      },
      "autoShutdownNotificationLocale": {
        "type": "String",
        "value": "en"
      },
      "autoShutdownNotificationEmail": {
        "type": "String",
        "value": "nassiri.kamal92@gmail.com"
      },
      "sqlVirtualMachineLocation": {
        "type": "String",
        "value": "westeurope"
      },
      "sqlVirtualMachineName": {
        "type": "String",
        "value": "UdemyCourseonP"
      },
      "sqlConnectivityType": {
        "type": "String",
        "value": "Public"
      },
      "sqlPortNumber": {
        "type": "Int",
        "value": 1433
      },
      "sqlStorageDisksCount": {
        "type": "Int",
        "value": 1
      },
      "sqlStorageWorkloadType": {
        "type": "String",
        "value": "OLTP"
      },
      "sqlStorageDisksConfigurationType": {
        "type": "String",
        "value": "NEW"
      },
      "sqlStorageStartingDeviceId": {
        "type": "Int",
        "value": 2
      },
      "sqlStorageDeploymentToken": {
        "type": "Int",
        "value": 51064
      },
      "sqlAutopatchingDayOfWeek": {
        "type": "String",
        "value": "Sunday"
      },
      "sqlAutopatchingStartHour": {
        "type": "String",
        "value": "2"
      },
      "sqlAutopatchingWindowDuration": {
        "type": "String",
        "value": "60"
      },
      "sqlAuthenticationLogin": {
        "type": "String",
        "value": "kamval"
      },
      "sqlAuthenticationPassword": {
        "type": "SecureString"
      },
      "dataPath": {
        "type": "String",
        "value": "F:\\data"
      },
      "dataDisksLUNs": {
        "type": "Array",
        "value": [
          0
        ]
      },
      "logPath": {
        "type": "String",
        "value": "G:\\log"
      },
      "logDisksLUNs": {
        "type": "Array",
        "value": [
          1
        ]
      },
      "tempDbPath": {
        "type": "String",
        "value": "D:\\tempDb"
      },
      "dataFileCount": {
        "type": "Int",
        "value": 1
      },
      "dataFileSize": {
        "type": "Int",
        "value": 8
      },
      "dataGrowth": {
        "type": "Int",
        "value": 64
      },
      "logFileSize": {
        "type": "Int",
        "value": 8
      },
      "logGrowth": {
        "type": "Int",
        "value": 64
      },
      "sqlSystemDbOnDataDisk": {
        "type": "Bool",
        "value": false
      },
      "rServicesEnabled": {
        "type": "String",
        "value": "false"
      },
      "maxdop": {
        "type": "Int",
        "value": 0
      },
      "isOptimizeForAdHocWorkloadsEnabled": {
        "type": "Bool",
        "value": false
      },
      "collation": {
        "type": "String",
        "value": "SQL_Latin1_General_CP1_CI_AS"
      },
      "minServerMemoryMB": {
        "type": "Int",
        "value": 0
      },
      "maxServerMemoryMB": {
        "type": "Int",
        "value": 2147483647
      },
      "isLPIMEnabled": {
        "type": "Bool",
        "value": false
      },
      "isIFIEnabled": {
        "type": "Bool",
        "value": false
      }
    },
    "mode": "Incremental",
    "debugSetting": {
      "detailLevel": "None"
    },
    "provisioningState": "Failed",
    "timestamp": "2022-08-24T21:12:14.8364828Z",
    "duration": "PT10M25.2562015S",
    "correlationId": "f9af5b54-2347-48fc-8521-0f7dd274274f",
    "providers": [
      {
        "namespace": "Microsoft.Network",
        "resourceTypes": [
          {
            "resourceType": "networkInterfaces",
            "locations": [
              "westeurope"
            ]
          },
          {
            "resourceType": "networkSecurityGroups",
            "locations": [
              "westeurope"
            ]
          },
          {
            "resourceType": "virtualNetworks",
            "locations": [
              "westeurope"
            ]
          },
          {
            "resourceType": "publicIpAddresses",
            "locations": [
              "westeurope"
            ]
          }
        ]
      },
      {
        "namespace": "Microsoft.Compute",
        "resourceTypes": [
          {
            "resourceType": "virtualMachines",
            "locations": [
              "westeurope"
            ]
          },
          {
            "resourceType": "disks",
            "locations": [
              "westeurope"
            ]
          }
        ]
      },
      {
        "namespace": "Microsoft.DevTestLab",
        "resourceTypes": [
          {
            "resourceType": "schedules",
            "locations": [
              "westeurope"
            ]
          }
        ]
      },
      {
        "namespace": "Microsoft.SqlVirtualMachine",
        "resourceTypes": [
          {
            "resourceType": "SqlVirtualMachines",
            "locations": [
              "westeurope"
            ]
          }
        ]
      }
    ],
    "dependencies": [
      {
        "dependsOn": [
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Network/networkSecurityGroups/UdemyCourseonP-nsg",
            "resourceType": "Microsoft.Network/networkSecurityGroups",
            "resourceName": "UdemyCourseonP-nsg"
          },
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Network/virtualNetworks/Udemy-vnet",
            "resourceType": "Microsoft.Network/virtualNetworks",
            "resourceName": "Udemy-vnet"
          },
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Network/publicIpAddresses/UdemyCourseonP-ip",
            "resourceType": "Microsoft.Network/publicIpAddresses",
            "resourceName": "UdemyCourseonP-ip"
          }
        ],
        "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Network/networkInterfaces/udemycourseonp527",
        "resourceType": "Microsoft.Network/networkInterfaces",
        "resourceName": "udemycourseonp527"
      },
      {
        "dependsOn": [
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Compute/disks/UdemyCourseonP_DataDisk_0",
            "resourceType": "Microsoft.Compute/disks",
            "resourceName": "UdemyCourseonP_DataDisk_0"
          },
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Compute/disks/UdemyCourseonP_DataDisk_1",
            "resourceType": "Microsoft.Compute/disks",
            "resourceName": "UdemyCourseonP_DataDisk_1"
          },
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Network/networkInterfaces/udemycourseonp527",
            "resourceType": "Microsoft.Network/networkInterfaces",
            "resourceName": "udemycourseonp527"
          }
        ],
        "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Compute/virtualMachines/UdemyCourseonP",
        "resourceType": "Microsoft.Compute/virtualMachines",
        "resourceName": "UdemyCourseonP"
      },
      {
        "dependsOn": [
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Compute/virtualMachines/UdemyCourseonP",
            "resourceType": "Microsoft.Compute/virtualMachines",
            "resourceName": "UdemyCourseonP"
          }
        ],
        "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.DevTestLab/schedules/shutdown-computevm-UdemyCourseonP",
        "resourceType": "Microsoft.DevTestLab/schedules",
        "resourceName": "shutdown-computevm-UdemyCourseonP"
      },
      {
        "dependsOn": [
          {
            "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.Compute/virtualMachines/UdemyCourseonP",
            "resourceType": "Microsoft.Compute/virtualMachines",
            "resourceName": "UdemyCourseonP"
          }
        ],
        "id": "/subscriptions/2040ce90-f9e1-44e7-9289-a504bbcabe1e/resourceGroups/Udemy/providers/Microsoft.SqlVirtualMachine/SqlVirtualMachines/UdemyCourseonP",
        "resourceType": "Microsoft.SqlVirtualMachine/SqlVirtualMachines",
        "resourceName": "UdemyCourseonP"
      }
    ],
    "error": {
      "code": "DeploymentFailed",
      "message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/DeployOperations for usage details.",
      "details": [
        {
          "code": "Ext_SqlIaasExtensionError",
          "message": "Error: 'Service with name 'MSSQLSERVER' does not exist or is not running. Please make sure service 'MSSQLSERVER' is running and retry this operation.\r\n\r\nMore information on troubleshooting is available at https://aka.ms/vmextensionwindowstroubleshoot '"
        }
      ]
    },
    "validationLevel": "Template"
  }
}