Microsoft.AzureArcData sqlServerInstances

Bicep resource definition

The sqlServerInstances resource type can be deployed with operations that target:

Resource groups - See resource group deployment commands

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.AzureArcData/sqlServerInstances resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.AzureArcData/sqlServerInstances@2026-03-01-preview' = {
  location: 'string'
  name: 'string'
  properties: {
    authentication: {
      mode: 'string'
      sqlServerEntraIdentity: [
        {
          clientId: 'string'
          identityType: 'string'
        }
      ]
    }
    backupPolicy: {
      differentialBackupHours: int
      fullBackupDays: int
      retentionPeriodDays: int
      transactionLogBackupMinutes: int
    }
    bestPracticesAssessment: {
      enabled: bool
      schedule: {
        cronTrigger: {
          expression: 'string'
          startTime: 'string'
          timeZone: 'string'
        }
        enabled: bool
      }
    }
    clientConnection: {
      enabled: bool
    }
    cores: 'string'
    databaseMirroringEndpoint: {}
    discoverySource: 'string'
    edition: 'string'
    failoverCluster: {}
    hostType: 'string'
    instanceName: 'string'
    migration: {
      assessment: {
        assessmentViewedTime: 'string'
        enabled: bool
        impactedObjectsSummary: {}
        settings: {
          comfortFactor: int
          costOptions: {
            computeAndStorageCostOption: 'string'
            sqlLicenseCostOption: 'string'
            windowsLicenseCostOption: 'string'
          }
          currency: 'string'
          discountPercentage: int
          lookbackPeriodInDays: int
          percentile: int
          strategy: 'string'
          targetLocation: 'string'
        }
      }
      targetResourceId: 'string'
      targetSelectedTime: 'string'
    }
    monitoring: {
      enabled: bool
    }
    serviceType: 'string'
    upgradeLockedUntil: 'string'
    version: 'string'
  }
  tags: {
    {customized property}: 'string'
  }
}

Property Values

Microsoft.AzureArcData/sqlServerInstances

Name	Description	Value
location	The geo-location where the resource lives	string (required)
name	The resource name	string (required)
properties	null	SqlServerInstanceProperties
tags	Resource tags	Dictionary of tag names and values. See Tags in templates

Authentication

Name	Description	Value
mode	Mode of authentication in SqlServer.	'Mixed' 'Undefined' 'Windows'
sqlServerEntraIdentity	Entra Authentication configuration for the SQL Server Instance.	EntraAuthentication[]

BackupPolicy

Name	Description	Value
differentialBackupHours	The differential backup interval in hours.	int
fullBackupDays	The value indicating days between full backups.	int Constraints: Min value = 0 Max value = 7
retentionPeriodDays	The retention period for all the databases in this managed instance.	int Constraints: Min value = 0 Max value = 35
transactionLogBackupMinutes	The value indicating minutes between transaction log backups.	int Constraints: Min value = 0 Max value = 60

BestPracticesAssessment

Name	Description	Value
enabled	Indicates if SQL best practices assessment is enabled for the SQL Server instance.	bool
schedule	The scheduling configuration.	Schedule

ClientConnection

Name	Description	Value
enabled	Indicates if client connection is enabled for this SQL Server instance.	bool

CostOptionSelectedValues

Name	Description	Value
computeAndStorageCostOption	selected cost saving option e.g. With1YearASPAndDevTest.	string
sqlLicenseCostOption	With Azure Hybrid Benefit(AHB) or not for SQL.	string
windowsLicenseCostOption	With Azure Hybrid Benefit(AHB) or not for Windows.	string

CronTrigger

Name	Description	Value
expression	A cron string representing a CronTab expression. A crontab expression is a very compact way to express a recurring schedule with the following format: '{minutes} {hours} {days} {months} {days-of-week}'.	string
startTime	Indicates the start time for the trigger. The default value is the time at which the trigger was created.	string
timeZone	The time zone in which the trigger is scheduled.	string

DBMEndpoint

Name	Description	Value

EntraAuthentication

Name	Description	Value
clientId	The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.	string
identityType	The method used for Entra authentication	'SystemAssignedManagedIdentity' 'UserAssignedManagedIdentity'

FailoverCluster

Name	Description	Value

ImpactedObjectsSuitabilitySummary

Name	Description	Value

Migration

Name	Description	Value
assessment	Migration assessments related configuration.	MigrationAssessment
targetResourceId	Resource Id of the created or selected target SQL resource for migration.	string
targetSelectedTime	The last time when the target resource was selected for migration.	string

MigrationAssessment

Name	Description	Value
assessmentViewedTime	The time when this migration assessment was last viewed.	string
enabled	Indicates if migration assessment is enabled for this SQL Server instance.	bool
impactedObjectsSummary	Represents a summary of migration readiness issues/warnings per feature type for Azure SQL DB and SQL MI targets	ImpactedObjectsSuitabilitySummary
settings	Settings impacting the migration assessment computation - configurable with some default values if not set.	MigrationAssessmentSettings

MigrationAssessmentSettings

Name	Description	Value
comfortFactor	Buffer (percentage) to consider while SKU sizing to account for issues such as seasonal usage, short performance history, and likely increases in future usage - This buffer is applied on top of the performance metrics. Default is 100 (percent).	int
costOptions	Selected cost option value.	CostOptionSelectedValues
currency	currency to calculate prices - Default is USD.	string
discountPercentage	flat discount percentage to apply for the price - Default is 0	int
lookbackPeriodInDays	How far back to check the performance data - Default is 30 (days).	int
percentile	Indicate the percentile value for the performance sample. Default is 95th percentile.	int
strategy	Minimize cost or Migrate to PaaS. - to evaluate based on the recommended strategy. Default is Migrate to PaaS	string
targetLocation	The target location for Azure SQL SKU for migration. Default is West US.	string

Monitoring

Name	Description	Value
enabled	Indicates if monitoring is enabled for this SQL Server instance.	bool

Schedule

Name	Description	Value
cronTrigger	The cron trigger configuration.	CronTrigger
enabled	Indicates whether scheduling is enabled.	bool

SqlServerInstanceProperties

Name	Description	Value
authentication	Authentication related configuration for the SQL Server Instance.	Authentication
backupPolicy	The backup profile for the SQL server.	BackupPolicy
bestPracticesAssessment	The configuration related to SQL best practices assessment.	BestPracticesAssessment
clientConnection	Client connection related configuration.	ClientConnection
cores	The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.	string
databaseMirroringEndpoint	Database mirroring endpoint related properties.	DBMEndpoint
discoverySource	Indicates the discovery agent or client for this instance.	'ADS' 'Azure Arc' 'Azure Migrate' 'DMS-CLI' 'DMS-Portal' 'DMS-PS' 'DMS-SDK' 'Import' 'Other' 'SSMA' 'SSMS'
edition	SQL Server edition.	'Business Intelligence' 'Developer' 'Enterprise' 'Evaluation' 'Express' 'Standard Developer' 'Standard' 'Unknown' 'Web'
failoverCluster	Failover Cluster Instance properties.	FailoverCluster
hostType	Type of host for Azure Arc SQL Server	'AWS Kubernetes Service' 'AWS Virtual Machine' 'AWS VMWare Virtual Machine' 'Azure Kubernetes Service' 'Azure Virtual Machine' 'Azure VMWare Virtual Machine' 'Container' 'GCP Kubernetes Service' 'GCP Virtual Machine' 'GCP VMWare Virtual Machine' 'Hyper-V Virtual Machine' 'Other' 'Physical Server' 'Virtual Machine'
instanceName	SQL Server instance name.	string
migration	Migration related configuration and status.	Migration
monitoring	The monitoring configuration.	Monitoring
serviceType	Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.	'Engine' 'PBIRS' 'SSAS' 'SSIS' 'SSRS'
upgradeLockedUntil	Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.	string
version	SQL Server version.	'SQL Server 2012' 'SQL Server 2014' 'SQL Server 2016' 'SQL Server 2017' 'SQL Server 2019' 'SQL Server 2022' 'SQL Server 2025' 'Unknown'

TrackedResourceTags

Name	Description	Value

ARM template resource definition

The sqlServerInstances resource type can be deployed with operations that target:

Resource groups - See resource group deployment commands For a list of changed properties in each API version, see change log.

Usage Examples

Resource format

To create a Microsoft.AzureArcData/sqlServerInstances resource, add the following JSON to your template.

{
  "type": "Microsoft.AzureArcData/sqlServerInstances",
  "apiVersion": "2026-03-01-preview",
  "name": "string",
  "location": "string",
  "properties": {
    "authentication": {
      "mode": "string",
      "sqlServerEntraIdentity": [
        {
          "clientId": "string",
          "identityType": "string"
        }
      ]
    },
    "backupPolicy": {
      "differentialBackupHours": "int",
      "fullBackupDays": "int",
      "retentionPeriodDays": "int",
      "transactionLogBackupMinutes": "int"
    },
    "bestPracticesAssessment": {
      "enabled": "bool",
      "schedule": {
        "cronTrigger": {
          "expression": "string",
          "startTime": "string",
          "timeZone": "string"
        },
        "enabled": "bool"
      }
    },
    "clientConnection": {
      "enabled": "bool"
    },
    "cores": "string",
    "databaseMirroringEndpoint": {
    },
    "discoverySource": "string",
    "edition": "string",
    "failoverCluster": {
    },
    "hostType": "string",
    "instanceName": "string",
    "migration": {
      "assessment": {
        "assessmentViewedTime": "string",
        "enabled": "bool",
        "impactedObjectsSummary": {
        },
        "settings": {
          "comfortFactor": "int",
          "costOptions": {
            "computeAndStorageCostOption": "string",
            "sqlLicenseCostOption": "string",
            "windowsLicenseCostOption": "string"
          },
          "currency": "string",
          "discountPercentage": "int",
          "lookbackPeriodInDays": "int",
          "percentile": "int",
          "strategy": "string",
          "targetLocation": "string"
        }
      },
      "targetResourceId": "string",
      "targetSelectedTime": "string"
    },
    "monitoring": {
      "enabled": "bool"
    },
    "serviceType": "string",
    "upgradeLockedUntil": "string",
    "version": "string"
  },
  "tags": {
    "{customized property}": "string"
  }
}

Property Values

Microsoft.AzureArcData/sqlServerInstances

Name	Description	Value
apiVersion	The api version	'2026-03-01-preview'
location	The geo-location where the resource lives	string (required)
name	The resource name	string (required)
properties	null	SqlServerInstanceProperties
tags	Resource tags	Dictionary of tag names and values. See Tags in templates
type	The resource type	'Microsoft.AzureArcData/sqlServerInstances'

Authentication

Name	Description	Value
mode	Mode of authentication in SqlServer.	'Mixed' 'Undefined' 'Windows'
sqlServerEntraIdentity	Entra Authentication configuration for the SQL Server Instance.	EntraAuthentication[]

BackupPolicy

Name	Description	Value
differentialBackupHours	The differential backup interval in hours.	int
fullBackupDays	The value indicating days between full backups.	int Constraints: Min value = 0 Max value = 7
retentionPeriodDays	The retention period for all the databases in this managed instance.	int Constraints: Min value = 0 Max value = 35
transactionLogBackupMinutes	The value indicating minutes between transaction log backups.	int Constraints: Min value = 0 Max value = 60

BestPracticesAssessment

Name	Description	Value
enabled	Indicates if SQL best practices assessment is enabled for the SQL Server instance.	bool
schedule	The scheduling configuration.	Schedule

ClientConnection

Name	Description	Value
enabled	Indicates if client connection is enabled for this SQL Server instance.	bool

CostOptionSelectedValues

Name	Description	Value
computeAndStorageCostOption	selected cost saving option e.g. With1YearASPAndDevTest.	string
sqlLicenseCostOption	With Azure Hybrid Benefit(AHB) or not for SQL.	string
windowsLicenseCostOption	With Azure Hybrid Benefit(AHB) or not for Windows.	string

CronTrigger

Name	Description	Value
expression	A cron string representing a CronTab expression. A crontab expression is a very compact way to express a recurring schedule with the following format: '{minutes} {hours} {days} {months} {days-of-week}'.	string
startTime	Indicates the start time for the trigger. The default value is the time at which the trigger was created.	string
timeZone	The time zone in which the trigger is scheduled.	string

DBMEndpoint

Name	Description	Value

EntraAuthentication

Name	Description	Value
clientId	The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.	string
identityType	The method used for Entra authentication	'SystemAssignedManagedIdentity' 'UserAssignedManagedIdentity'

FailoverCluster

Name	Description	Value

ImpactedObjectsSuitabilitySummary

Name	Description	Value

Migration

Name	Description	Value
assessment	Migration assessments related configuration.	MigrationAssessment
targetResourceId	Resource Id of the created or selected target SQL resource for migration.	string
targetSelectedTime	The last time when the target resource was selected for migration.	string

MigrationAssessment

Name	Description	Value
assessmentViewedTime	The time when this migration assessment was last viewed.	string
enabled	Indicates if migration assessment is enabled for this SQL Server instance.	bool
impactedObjectsSummary	Represents a summary of migration readiness issues/warnings per feature type for Azure SQL DB and SQL MI targets	ImpactedObjectsSuitabilitySummary
settings	Settings impacting the migration assessment computation - configurable with some default values if not set.	MigrationAssessmentSettings

MigrationAssessmentSettings

Name	Description	Value
comfortFactor	Buffer (percentage) to consider while SKU sizing to account for issues such as seasonal usage, short performance history, and likely increases in future usage - This buffer is applied on top of the performance metrics. Default is 100 (percent).	int
costOptions	Selected cost option value.	CostOptionSelectedValues
currency	currency to calculate prices - Default is USD.	string
discountPercentage	flat discount percentage to apply for the price - Default is 0	int
lookbackPeriodInDays	How far back to check the performance data - Default is 30 (days).	int
percentile	Indicate the percentile value for the performance sample. Default is 95th percentile.	int
strategy	Minimize cost or Migrate to PaaS. - to evaluate based on the recommended strategy. Default is Migrate to PaaS	string
targetLocation	The target location for Azure SQL SKU for migration. Default is West US.	string

Monitoring

Name	Description	Value
enabled	Indicates if monitoring is enabled for this SQL Server instance.	bool

Schedule

Name	Description	Value
cronTrigger	The cron trigger configuration.	CronTrigger
enabled	Indicates whether scheduling is enabled.	bool

SqlServerInstanceProperties

Name	Description	Value
authentication	Authentication related configuration for the SQL Server Instance.	Authentication
backupPolicy	The backup profile for the SQL server.	BackupPolicy
bestPracticesAssessment	The configuration related to SQL best practices assessment.	BestPracticesAssessment
clientConnection	Client connection related configuration.	ClientConnection
cores	The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.	string
databaseMirroringEndpoint	Database mirroring endpoint related properties.	DBMEndpoint
discoverySource	Indicates the discovery agent or client for this instance.	'ADS' 'Azure Arc' 'Azure Migrate' 'DMS-CLI' 'DMS-Portal' 'DMS-PS' 'DMS-SDK' 'Import' 'Other' 'SSMA' 'SSMS'
edition	SQL Server edition.	'Business Intelligence' 'Developer' 'Enterprise' 'Evaluation' 'Express' 'Standard Developer' 'Standard' 'Unknown' 'Web'
failoverCluster	Failover Cluster Instance properties.	FailoverCluster
hostType	Type of host for Azure Arc SQL Server	'AWS Kubernetes Service' 'AWS Virtual Machine' 'AWS VMWare Virtual Machine' 'Azure Kubernetes Service' 'Azure Virtual Machine' 'Azure VMWare Virtual Machine' 'Container' 'GCP Kubernetes Service' 'GCP Virtual Machine' 'GCP VMWare Virtual Machine' 'Hyper-V Virtual Machine' 'Other' 'Physical Server' 'Virtual Machine'
instanceName	SQL Server instance name.	string
migration	Migration related configuration and status.	Migration
monitoring	The monitoring configuration.	Monitoring
serviceType	Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.	'Engine' 'PBIRS' 'SSAS' 'SSIS' 'SSRS'
upgradeLockedUntil	Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.	string
version	SQL Server version.	'SQL Server 2012' 'SQL Server 2014' 'SQL Server 2016' 'SQL Server 2017' 'SQL Server 2019' 'SQL Server 2022' 'SQL Server 2025' 'Unknown'

TrackedResourceTags

Name	Description	Value

Terraform (AzAPI provider) resource definition

The sqlServerInstances resource type can be deployed with operations that target:

Resource groups For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.AzureArcData/sqlServerInstances resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.AzureArcData/sqlServerInstances@2026-03-01-preview"
  name = "string"
  parent_id = "string"
  location = "string"
  tags = {
    {customized property} = "string"
  }
  body = {
    properties = {
      authentication = {
        mode = "string"
        sqlServerEntraIdentity = [
          {
            clientId = "string"
            identityType = "string"
          }
        ]
      }
      backupPolicy = {
        differentialBackupHours = int
        fullBackupDays = int
        retentionPeriodDays = int
        transactionLogBackupMinutes = int
      }
      bestPracticesAssessment = {
        enabled = bool
        schedule = {
          cronTrigger = {
            expression = "string"
            startTime = "string"
            timeZone = "string"
          }
          enabled = bool
        }
      }
      clientConnection = {
        enabled = bool
      }
      cores = "string"
      databaseMirroringEndpoint = {
      }
      discoverySource = "string"
      edition = "string"
      failoverCluster = {
      }
      hostType = "string"
      instanceName = "string"
      migration = {
        assessment = {
          assessmentViewedTime = "string"
          enabled = bool
          impactedObjectsSummary = {
          }
          settings = {
            comfortFactor = int
            costOptions = {
              computeAndStorageCostOption = "string"
              sqlLicenseCostOption = "string"
              windowsLicenseCostOption = "string"
            }
            currency = "string"
            discountPercentage = int
            lookbackPeriodInDays = int
            percentile = int
            strategy = "string"
            targetLocation = "string"
          }
        }
        targetResourceId = "string"
        targetSelectedTime = "string"
      }
      monitoring = {
        enabled = bool
      }
      serviceType = "string"
      upgradeLockedUntil = "string"
      version = "string"
    }
  }
}

Property Values

Microsoft.AzureArcData/sqlServerInstances

Name	Description	Value
location	The geo-location where the resource lives	string (required)
name	The resource name	string (required)
properties	null	SqlServerInstanceProperties
tags	Resource tags	Dictionary of tag names and values.
type	The resource type	"Microsoft.AzureArcData/sqlServerInstances@2026-03-01-preview"

Authentication

Name	Description	Value
mode	Mode of authentication in SqlServer.	'Mixed' 'Undefined' 'Windows'
sqlServerEntraIdentity	Entra Authentication configuration for the SQL Server Instance.	EntraAuthentication[]

BackupPolicy

Name	Description	Value
differentialBackupHours	The differential backup interval in hours.	int
fullBackupDays	The value indicating days between full backups.	int Constraints: Min value = 0 Max value = 7
retentionPeriodDays	The retention period for all the databases in this managed instance.	int Constraints: Min value = 0 Max value = 35
transactionLogBackupMinutes	The value indicating minutes between transaction log backups.	int Constraints: Min value = 0 Max value = 60

BestPracticesAssessment

Name	Description	Value
enabled	Indicates if SQL best practices assessment is enabled for the SQL Server instance.	bool
schedule	The scheduling configuration.	Schedule

ClientConnection

Name	Description	Value
enabled	Indicates if client connection is enabled for this SQL Server instance.	bool

CostOptionSelectedValues

Name	Description	Value
computeAndStorageCostOption	selected cost saving option e.g. With1YearASPAndDevTest.	string
sqlLicenseCostOption	With Azure Hybrid Benefit(AHB) or not for SQL.	string
windowsLicenseCostOption	With Azure Hybrid Benefit(AHB) or not for Windows.	string

CronTrigger

Name	Description	Value
expression	A cron string representing a CronTab expression. A crontab expression is a very compact way to express a recurring schedule with the following format: '{minutes} {hours} {days} {months} {days-of-week}'.	string
startTime	Indicates the start time for the trigger. The default value is the time at which the trigger was created.	string
timeZone	The time zone in which the trigger is scheduled.	string

DBMEndpoint

Name	Description	Value

EntraAuthentication

Name	Description	Value
clientId	The client Id of the Managed Identity to query Microsoft Graph API. An empty string must be used for the system assigned Managed Identity.	string
identityType	The method used for Entra authentication	'SystemAssignedManagedIdentity' 'UserAssignedManagedIdentity'

FailoverCluster

Name	Description	Value

ImpactedObjectsSuitabilitySummary

Name	Description	Value

Migration

Name	Description	Value
assessment	Migration assessments related configuration.	MigrationAssessment
targetResourceId	Resource Id of the created or selected target SQL resource for migration.	string
targetSelectedTime	The last time when the target resource was selected for migration.	string

MigrationAssessment

Name	Description	Value
assessmentViewedTime	The time when this migration assessment was last viewed.	string
enabled	Indicates if migration assessment is enabled for this SQL Server instance.	bool
impactedObjectsSummary	Represents a summary of migration readiness issues/warnings per feature type for Azure SQL DB and SQL MI targets	ImpactedObjectsSuitabilitySummary
settings	Settings impacting the migration assessment computation - configurable with some default values if not set.	MigrationAssessmentSettings

MigrationAssessmentSettings

Name	Description	Value
comfortFactor	Buffer (percentage) to consider while SKU sizing to account for issues such as seasonal usage, short performance history, and likely increases in future usage - This buffer is applied on top of the performance metrics. Default is 100 (percent).	int
costOptions	Selected cost option value.	CostOptionSelectedValues
currency	currency to calculate prices - Default is USD.	string
discountPercentage	flat discount percentage to apply for the price - Default is 0	int
lookbackPeriodInDays	How far back to check the performance data - Default is 30 (days).	int
percentile	Indicate the percentile value for the performance sample. Default is 95th percentile.	int
strategy	Minimize cost or Migrate to PaaS. - to evaluate based on the recommended strategy. Default is Migrate to PaaS	string
targetLocation	The target location for Azure SQL SKU for migration. Default is West US.	string

Monitoring

Name	Description	Value
enabled	Indicates if monitoring is enabled for this SQL Server instance.	bool

Schedule

Name	Description	Value
cronTrigger	The cron trigger configuration.	CronTrigger
enabled	Indicates whether scheduling is enabled.	bool

SqlServerInstanceProperties

Name	Description	Value
authentication	Authentication related configuration for the SQL Server Instance.	Authentication
backupPolicy	The backup profile for the SQL server.	BackupPolicy
bestPracticesAssessment	The configuration related to SQL best practices assessment.	BestPracticesAssessment
clientConnection	Client connection related configuration.	ClientConnection
cores	The number of total cores of the Operating System Environment (OSE) hosting the SQL Server instance.	string
databaseMirroringEndpoint	Database mirroring endpoint related properties.	DBMEndpoint
discoverySource	Indicates the discovery agent or client for this instance.	'ADS' 'Azure Arc' 'Azure Migrate' 'DMS-CLI' 'DMS-Portal' 'DMS-PS' 'DMS-SDK' 'Import' 'Other' 'SSMA' 'SSMS'
edition	SQL Server edition.	'Business Intelligence' 'Developer' 'Enterprise' 'Evaluation' 'Express' 'Standard Developer' 'Standard' 'Unknown' 'Web'
failoverCluster	Failover Cluster Instance properties.	FailoverCluster
hostType	Type of host for Azure Arc SQL Server	'AWS Kubernetes Service' 'AWS Virtual Machine' 'AWS VMWare Virtual Machine' 'Azure Kubernetes Service' 'Azure Virtual Machine' 'Azure VMWare Virtual Machine' 'Container' 'GCP Kubernetes Service' 'GCP Virtual Machine' 'GCP VMWare Virtual Machine' 'Hyper-V Virtual Machine' 'Other' 'Physical Server' 'Virtual Machine'
instanceName	SQL Server instance name.	string
migration	Migration related configuration and status.	Migration
monitoring	The monitoring configuration.	Monitoring
serviceType	Indicates if the resource represents a SQL Server engine or a SQL Server component service installed on the host.	'Engine' 'PBIRS' 'SSAS' 'SSIS' 'SSRS'
upgradeLockedUntil	Upgrade Action for this resource is locked until it expires. The Expiration time indicated by this value. It is not locked when it is empty.	string
version	SQL Server version.	'SQL Server 2012' 'SQL Server 2014' 'SQL Server 2016' 'SQL Server 2017' 'SQL Server 2019' 'SQL Server 2022' 'SQL Server 2025' 'Unknown'

TrackedResourceTags

Name	Description	Value

Feedback

Was this page helpful?

Last updated on 2026-07-13

Microsoft.AzureArcData sqlServerInstances

Bicep resource definition

Resource format

Property Values

Microsoft.AzureArcData/sqlServerInstances

Authentication

BackupPolicy

BestPracticesAssessment

ClientConnection

CostOptionSelectedValues

CronTrigger

DBMEndpoint

EntraAuthentication

FailoverCluster

ImpactedObjectsSuitabilitySummary

Migration

MigrationAssessment

MigrationAssessmentSettings

Monitoring

Schedule

SqlServerInstanceProperties

TrackedResourceTags

ARM template resource definition

Usage Examples

Resource format

Property Values

Microsoft.AzureArcData/sqlServerInstances

Authentication

BackupPolicy

BestPracticesAssessment

ClientConnection

CostOptionSelectedValues

CronTrigger

DBMEndpoint

EntraAuthentication

FailoverCluster

ImpactedObjectsSuitabilitySummary

Migration

MigrationAssessment

MigrationAssessmentSettings

Monitoring

Schedule

SqlServerInstanceProperties

TrackedResourceTags

Terraform (AzAPI provider) resource definition

Resource format

Property Values

Microsoft.AzureArcData/sqlServerInstances

Authentication

BackupPolicy

BestPracticesAssessment

ClientConnection

CostOptionSelectedValues

CronTrigger

DBMEndpoint

EntraAuthentication

FailoverCluster

ImpactedObjectsSuitabilitySummary

Migration

MigrationAssessment

MigrationAssessmentSettings

Monitoring

Schedule

SqlServerInstanceProperties

TrackedResourceTags

Feedback

Additional resources