Microsoft. Server SQL/virtualNetworkRules

Definisi sumber daya Bicep

Jenis sumber daya server/virtualNetworkRules dapat disebarkan dengan operasi yang menargetkan:

  • Grup sumber daya - Lihat perintah penyebaran grup sumber daya

Untuk daftar properti yang diubah di setiap versi API, lihat mengubah log.

Contoh Penggunaan

Sampel Bicep

Contoh dasar penerapan Azure SQL Virtual Network Rule.

@secure()
@description('The administrator password for the SQL server')
param sqlAdministratorPassword string
param resourceName string = 'acctest0001'
param location string = 'westeurope'

resource virtualNetwork 'Microsoft.Network/virtualNetworks@2022-07-01' = {
  name: resourceName
  location: location
  properties: {
    addressSpace: {
      addressPrefixes: [
        '10.7.28.0/23'
      ]
    }
    dhcpOptions: {
      dnsServers: []
    }
    subnets: []
  }
}

resource subnet 'Microsoft.Network/virtualNetworks/subnets@2022-07-01' = {
  name: resourceName
  parent: virtualNetwork
  properties: {
    addressPrefix: '10.7.28.0/25'
    delegations: []
    privateEndpointNetworkPolicies: 'Enabled'
    privateLinkServiceNetworkPolicies: 'Enabled'
    serviceEndpointPolicies: []
    serviceEndpoints: [
      {
        service: 'Microsoft.Sql'
      }
    ]
  }
}

resource server 'Microsoft.Sql/servers@2021-02-01-preview' = {
  name: resourceName
  location: location
  properties: {
    administratorLogin: 'missadmin'
    administratorLoginPassword: sqlAdministratorPassword
    minimalTlsVersion: '1.2'
    publicNetworkAccess: 'Enabled'
    restrictOutboundNetworkAccess: 'Disabled'
    version: '12.0'
  }
}

resource virtualNetworkRule 'Microsoft.Sql/servers/virtualNetworkRules@2020-11-01-preview' = {
  name: resourceName
  parent: server
  properties: {
    ignoreMissingVnetServiceEndpoint: false
    virtualNetworkSubnetId: subnet.id
  }
}

Format sumber daya

Untuk membuat Microsoft. Sql/servers/virtualNetworkRules, tambahkan Bicep berikut ke templat Anda.

resource symbolicname 'Microsoft.Sql/servers/virtualNetworkRules@2026-08-01-preview' = {
  parent: resourceSymbolicName
  name: 'string'
  properties: {
    ignoreMissingVnetServiceEndpoint: bool
    virtualNetworkSubnetId: 'string'
  }
}

Nilai Properti

Microsoft. SQL/server/virtualNetworkRules

Name Description Value
name Nama sumber daya string (diperlukan)
induk Di Bicep, Anda dapat menentukan sumber daya induk untuk sumber daya turunan. Anda hanya perlu menambahkan properti ini ketika sumber daya anak dideklarasikan di luar sumber daya induk.

Untuk informasi selengkapnya, lihat sumber daya Turunan di luar sumber daya induk.		 Nama simbolis untuk sumber daya jenis: server
properties Properti sumber daya. VirtualNetworkRuleProperties

VirtualNetworkRuleProperties

Name Description Value
ignoreMissingVnetServiceEndpoint Buat aturan firewall sebelum jaringan virtual mengaktifkan titik akhir layanan vnet. bool
virtualNetworkSubnetId Id sumber daya ARM dari subnet jaringan virtual. string (diperlukan)

Definisi sumber daya templat ARM

Jenis sumber daya server/virtualNetworkRules dapat disebarkan dengan operasi yang menargetkan:

Contoh Penggunaan

Format sumber daya

Untuk membuat Microsoft. Sql/servers/virtualNetworkRules, tambahkan JSON berikut ke templat Anda.

{
  "type": "Microsoft.Sql/servers/virtualNetworkRules",
  "apiVersion": "2026-08-01-preview",
  "name": "string",
  "properties": {
    "ignoreMissingVnetServiceEndpoint": "bool",
    "virtualNetworkSubnetId": "string"
  }
}

Nilai Properti

Microsoft. SQL/server/virtualNetworkRules

Name Description Value
apiVersion Versi api '2026-08-01-pratinjau'
name Nama sumber daya string (diperlukan)
properties Properti sumber daya. VirtualNetworkRuleProperties
jenis Jenis sumber daya "Microsoft. SQL/server/virtualNetworkRules'

VirtualNetworkRuleProperties

Name Description Value
ignoreMissingVnetServiceEndpoint Buat aturan firewall sebelum jaringan virtual mengaktifkan titik akhir layanan vnet. bool
virtualNetworkSubnetId Id sumber daya ARM dari subnet jaringan virtual. string (diperlukan)

Definisi sumber daya Terraform (penyedia AzAPI)

Jenis sumber daya server/virtualNetworkRules dapat disebarkan dengan operasi yang menargetkan:

  • Grup sumber daya Untuk daftar properti yang diubah di setiap versi API, lihat log perubahan.

Contoh Penggunaan

Sampel Terraform

Contoh dasar penerapan Azure SQL Virtual Network Rule.

terraform {
  required_providers {
    azapi = {
      source = "Azure/azapi"
    }
  }
}

provider "azapi" {
  skip_provider_registration = false
}

variable "resource_name" {
  type    = string
  default = "acctest0001"
}

variable "location" {
  type    = string
  default = "westeurope"
}

variable "sql_administrator_password" {
  type        = string
  description = "The administrator password for the SQL server"
  sensitive   = true
}

resource "azapi_resource" "resourceGroup" {
  type     = "Microsoft.Resources/resourceGroups@2020-06-01"
  name     = var.resource_name
  location = var.location
}

resource "azapi_resource" "server" {
  type      = "Microsoft.Sql/servers@2021-02-01-preview"
  parent_id = azapi_resource.resourceGroup.id
  name      = var.resource_name
  location  = var.location
  body = {
    properties = {
      administratorLogin            = "missadmin"
      administratorLoginPassword    = var.sql_administrator_password
      minimalTlsVersion             = "1.2"
      publicNetworkAccess           = "Enabled"
      restrictOutboundNetworkAccess = "Disabled"
      version                       = "12.0"
    }
  }
  schema_validation_enabled = false
  response_export_values    = ["*"]
}

resource "azapi_resource" "virtualNetwork" {
  type      = "Microsoft.Network/virtualNetworks@2022-07-01"
  parent_id = azapi_resource.resourceGroup.id
  name      = var.resource_name
  location  = var.location
  body = {
    properties = {
      addressSpace = {
        addressPrefixes = [
          "10.7.28.0/23",
        ]
      }
      dhcpOptions = {
        dnsServers = [
        ]
      }
      subnets = [
      ]
    }
  }
  schema_validation_enabled = false
  response_export_values    = ["*"]
  lifecycle {
    ignore_changes = [body.properties.subnets]
  }
}

resource "azapi_resource" "subnet" {
  type      = "Microsoft.Network/virtualNetworks/subnets@2022-07-01"
  parent_id = azapi_resource.virtualNetwork.id
  name      = var.resource_name
  body = {
    properties = {
      addressPrefix = "10.7.28.0/25"
      delegations = [
      ]
      privateEndpointNetworkPolicies    = "Enabled"
      privateLinkServiceNetworkPolicies = "Enabled"
      serviceEndpointPolicies = [
      ]
      serviceEndpoints = [
        {
          service = "Microsoft.Sql"
        },
      ]
    }
  }
  schema_validation_enabled = false
  response_export_values    = ["*"]
}

resource "azapi_resource" "virtualNetworkRule" {
  type      = "Microsoft.Sql/servers/virtualNetworkRules@2020-11-01-preview"
  parent_id = azapi_resource.server.id
  name      = var.resource_name
  body = {
    properties = {
      ignoreMissingVnetServiceEndpoint = false
      virtualNetworkSubnetId           = azapi_resource.subnet.id
    }
  }
  schema_validation_enabled = false
  response_export_values    = ["*"]
}

Format sumber daya

Untuk membuat Microsoft. Sql/servers/virtualNetworkRules, tambahkan Terraform berikut ke templat Anda.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.Sql/servers/virtualNetworkRules@2026-08-01-preview"
  name = "string"
  parent_id = "string"
  body = {
    properties = {
      ignoreMissingVnetServiceEndpoint = bool
      virtualNetworkSubnetId = "string"
    }
  }
}

Nilai Properti

Microsoft. SQL/server/virtualNetworkRules

Name Description Value
name Nama sumber daya string (diperlukan)
parent_id ID sumber daya yang merupakan induk untuk sumber daya ini. ID untuk sumber daya jenis: server
properties Properti sumber daya. VirtualNetworkRuleProperties
jenis Jenis sumber daya "Microsoft. SQL/servers/virtualNetworkRules@2026-08-01-preview"

VirtualNetworkRuleProperties

Name Description Value
ignoreMissingVnetServiceEndpoint Buat aturan firewall sebelum jaringan virtual mengaktifkan titik akhir layanan vnet. bool
virtualNetworkSubnetId Id sumber daya ARM dari subnet jaringan virtual. string (diperlukan)
  • Terakhir diperbarui pada