last sync: 2022-Sep-30 16:34:23 UTC

Azure Policy definition

Configure Arc-enabled machines running SQL Server to have SQL Server extension installed.

Name Configure Arc-enabled machines running SQL Server to have SQL Server extension installed.
Azure Portal
Id fd2d1a6e-6d95-4df2-ad00-504bf0273406
Version 2.1.0
details on versioning
Category SQL
Microsoft docs
Description To ensure that SQL Server - Azure Arc resources are created by default when SQL Server instance is found on Azure Arc enabled Windows Server, the latter should have SQL Server extension installed and the server's managed identity should be configured with Azure Connected SQL Server Onboarding role
Mode Indexed
Type BuiltIn
Preview FALSE
Deprecated FALSE
Effect Default: DeployIfNotExists
Allowed: (DeployIfNotExists, Disabled)
Used RBAC Role
Role Name Role Id
Log Analytics Contributor 92aaf0da-9dab-42b6-94a3-d43ce8d16293
User Access Administrator 18d7d88d-d35e-4fb5-a5c3-7773c20a72d9
Rule Aliases IF (2)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.HybridCompute/imageOffer Microsoft.HybridCompute machines properties.osName false
Microsoft.HybridCompute/machines/mssqlDiscovered Microsoft.HybridCompute machines properties.mssqlDiscovered false
THEN-ExistenceCondition (3)
Alias Namespace ResourceType DefaultPath Modifiable
Microsoft.HybridCompute/machines/extensions/provisioningState Microsoft.HybridCompute machines/extensions properties.provisioningState false
Microsoft.HybridCompute/machines/extensions/publisher Microsoft.HybridCompute machines/extensions properties.publisher false
Microsoft.HybridCompute/machines/extensions/type Microsoft.HybridCompute machines/extensions properties.type false
Rule ResourceTypes IF (1)
THEN-Deployment (3)
Date/Time (UTC ymd) (i) Change type Change detail
2022-02-18 17:44:00 change Minor (2.0.0 > 2.1.0)
2021-09-27 15:52:17 change Major (1.0.1 > 2.0.0)
2021-09-08 15:39:57 change Patch (1.0.0 > 1.0.1) *changes on text case sensitivity are not tracked
2021-08-09 19:32:42 add fd2d1a6e-6d95-4df2-ad00-504bf0273406
Used in Initiatives none
JSON Changes