sqlServerInstances microsoft.azurearcdata/sqlserverinstances Azure Resource type

sqlServerInstances - Microsoft Azure Resource type
microsoft.azurearcdata/sqlserverinstances

Resource provider (RP) - Microsoft.AzureArcData [Microsoft.AzureArcData]
RP	Microsoft.AzureArcData
RP display name	Microsoft.AzureArcData
RP Resource types	Resource types: 13
RP aliases	RP aliases: 260
RP Azure Policy	Azure Policy definitions: 4 • if: 4 • then.deployment: 0 • then.details: 0 • then.existenceCondition: 0 • then.operations: 0
RP RBAC operations	RP RBAC operations: 57 • RP RBAC operationType action: 6 • RP RBAC operationType delete: 9 • RP RBAC operationType read: 25 • RP RBAC operationType write: 17
RP RBAC Roles & Operation actions	Unique RBAC Roles: 19 • RBAC Roles with action operationType: 5 • RBAC Roles with delete operationType: 4 • RBAC Roles with read operationType: 19 • RBAC Roles with write operationType: 5
RP related 1st party Service Principals	RP related 1st party Service Principals: 5 • TI-1P-APP (appId: b6a1fec6-8029-456b-81ed-de7754615362) [ JSON;CSV] • Prod-DPS-vNext-1P (appId: a665538c-5b51-48a1-b3a5-cf20f42c3785) • K8 Bridge (appId: 319f651f-7ddb-4fc6-9857-7aef9250bd05) [ JSON;CSV] • Azure Arc Data Services Billing (Azure Arc Data Processing Services) (appId: a12e8ccb-0fcd-46f8-b6a1-b9df7a9d7231) [ JSON;CSV] • Azure Arc Data Services (appId: bb55177b-a7d9-4939-a257-8ab53a3b2bc6) [ JSON;CSV]
All Azure RPs	• Microsoft Learn • AzResourceTypesAdvertizer (Microsoft only)

Resource provider (RP) - Microsoft.AzureArcData [Microsoft.AzureArcData]

Microsoft.AzureArcData

RP display name

Microsoft.AzureArcData

RP Resource types

Resource types: 13

RP aliases

RP aliases: 260

RP Azure Policy

Azure Policy definitions: 4
• if: 4
• then.deployment: 0
• then.details: 0
• then.existenceCondition: 0
• then.operations: 0

RP RBAC operations

RP RBAC operations: 57
• RP RBAC operationType action: 6
• RP RBAC operationType delete: 9
• RP RBAC operationType read: 25
• RP RBAC operationType write: 17

RP RBAC Roles & Operation actions

Unique RBAC Roles: 19
• RBAC Roles with action operationType: 5
• RBAC Roles with delete operationType: 4
• RBAC Roles with read operationType: 19
• RBAC Roles with write operationType: 5

RP related 1st party Service Principals

RP related 1st party Service Principals: 5
• TI-1P-APP (appId: b6a1fec6-8029-456b-81ed-de7754615362) [ JSON;CSV]
• Prod-DPS-vNext-1P (appId: a665538c-5b51-48a1-b3a5-cf20f42c3785)
• K8 Bridge (appId: 319f651f-7ddb-4fc6-9857-7aef9250bd05) [ JSON;CSV]
• Azure Arc Data Services Billing (Azure Arc Data Processing Services) (appId: a12e8ccb-0fcd-46f8-b6a1-b9df7a9d7231) [ JSON;CSV]
• Azure Arc Data Services (appId: bb55177b-a7d9-4939-a257-8ab53a3b2bc6) [ JSON;CSV]

All Azure RPs

• Microsoft Learn
• AzResourceTypesAdvertizer (Microsoft only)

RT information

microsoft.azurearcdata/sqlserverinstances

RT display name

sqlServerInstances

RT type only
(without RP)

SqlServerInstances

RT sub- Resource types

sub-Resource types: 2

RT schema

RT schema API versions: 10

• 2025-03-01-preview
• 2024-05-01-preview
• 2024-01-01
• 2023-01-15-preview
• 2022-06-15-preview
• 2022-03-01-preview
• 2021-11-01
• 2021-08-01
• 2021-07-01-preview
• 2021-06-01-preview

All Microsoft Azure RTs

AzResourceTypesAdvertizer

Aliases and Azure Policy

Aliases

aliases: 37

Azure Policy

Azure Policy definitions: 1
• if: 1
• then.deployment: 0
• then.details: 0
• then.existenceCondition: 0
• then.operations: 0

RBAC Operations and Roles & Roles related operation actions

RBAC operations

RBAC operations: 7
• RBAC operationType action: 1
• RBAC operationType delete: 1
• RBAC operationType read: 3
• RBAC operationType write: 2

RBAC Roles & Operation actions

Capabilities & Locations

Diagnostic logs

False

Azure Resource Diagnostic settings metrics

Diagnostic metrics

False

Customer-managed key (CMK) [experimental]

Unknown
• Enforce Encryption with a customer-managed key (CMK) at scale

System-Assigned-Resource-Identity

False

Cross-ResourceGroup-Resource-Move

False

Cross-Subscription-Resource-Move

False

Tags

True

Extension

False

Private-Endpoint

False

Supported Locations for Private-Endpoint

n/a

Non supported Locations for Private-Endpoint

n/a

Location

True

Locations

Locations: 27
australiaeast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastus, eastus2, francecentral, japaneast, koreacentral, northcentralus, northeurope, norwayeast, southafricanorth, southcentralus, southeastasia, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westus, westus2, westus3

Not locations

Not locations: 70
asia, asiapacific, australia, australiacentral, australiacentral2, australiasoutheast, brazil, brazilsoutheast, brazilus, canada, centraluseuap, centralusstage, eastasia, eastasiastage, eastus2euap, eastus2stage, eastusstage, eastusstg, europe, france, francesouth, germany, germanynorth, germanywestcentral, global, india, indonesia, indonesiacentral, israel, israelcentral, italy, italynorth, japan, japanwest, jioindiacentral, jioindiawest, korea, koreasouth, mexico, mexicocentral, newzealand, newzealandnorth, northcentralusstage, norway, norwaywest, poland, polandcentral, qatar, qatarcentral, singapore, southafrica, southafricawest, southcentralusstage, southcentralusstg, southeastasiastage, southindia, spain, spaincentral, sweden, switzerland, switzerlandwest, taiwan, uae, uaecentral, uk, unitedstates, unitedstateseuap, westindia, westus2stage, westusstage

Assessment tooling

Azure Advisor

Azure Advisor recommendations: 2
• Security [High] Microsoft Defender for SQL status should be protected for Arc-enabled SQL Servers
• Security [High] The status of Microsoft SQL Servers on Machines should be protected

Azure Proactive Resilience Library v2 (APRLv2)

n/a

PSRule for Azure

n/a

Azure Quick Review (AZQR)

n/a

Infrastructure as Code (IaC)

ARM (Azure Resource Manager) templates

ARM (Azure Resource Manager) template API versions: 10
• latest

Bicep templates

Bicep template API versions: 10
• latest

Terraform provider

n/a

AzAPI Terraform templates

AzAPI Terraform template API versions: 10
• latest

Pulumi provider

Pulumi providers: 1
• azurearcdata/sqlserverinstance

OpenTofu provider

n/a

Azure Verified Modules (AVM) Bicep

n/a

Azure Verified Modules (AVM) Terraform

n/a

REST-API (Representational State Transfer - Application Programming Interface)

REST-API versions

REST-API versions: 19

• 2025-04-01-preview
• 2025-03-01-preview
• 2024-12-01-preview
• 2024-09-01-preview
• 2024-05-01-preview
• 2024-04-01-preview
• 2024-03-01-preview
• 2024-02-01-preview
• 2024-01-01
• 2023-12-01-preview
• 2023-11-01-preview
• 2023-09-01-preview
• 2023-05-16-preview
• 2023-01-15-preview
• 2022-06-15-preview
• 2022-03-01-preview
• 2021-11-01
• 2021-08-01
• 2021-07-01-preview

REST-API version default

2024-09-01-preview

API profiles

n/a

Resource naming

Azure Naming Tool

The Azure Naming Tool was created to help administrators define and manage their naming conventions, while providing a simple interface for users to generate a compliant name.

Resource naming details

n/a

sqlServerInstances - Microsoft Azure Resource typemicrosoft.azurearcdata/sqlserverinstances

sqlServerInstances - Microsoft Azure Resource type
microsoft.azurearcdata/sqlserverinstances