last sync: 2023-Sep-26 18:00:51 UTC

Azure Policy definition

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

Source Azure Portal
Display name Configure Arc-enabled machines running SQL Server to have SQL Server extension installed.
Id fd2d1a6e-6d95-4df2-ad00-504bf0273406
Version 3.4.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/Linux Server, the latter should have SQL Server extension installed
Mode Indexed
Type BuiltIn
Preview False
Deprecated False
Effect Default
DeployIfNotExists
Allowed
DeployIfNotExists, Disabled
RBAC role(s)
Role Name Role Id
Azure Extension for SQL Server Deployment 7392c568-9289-4bde-aaaa-b7131215889d
Rule aliases IF (1)
Alias Namespace ResourceType DefaultPath Modifiable
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 resource types IF (1)
Microsoft.HybridCompute/machines
THEN-Deployment (1)
Microsoft.HybridCompute/machines/extensions
Compliance Not a Compliance control
Initiatives usage none
History
Date/Time (UTC ymd) (i) Change type Change detail
2023-03-31 17:44:15 change Minor (3.3.0 > 3.4.0)
2023-03-03 18:43:58 change Minor (3.2.0 > 3.3.0)
2023-01-27 18:40:07 change Minor (3.1.0 > 3.2.0)
2022-10-21 16:42:13 change Minor (3.0.0 > 3.1.0)
2022-10-07 16:34:28 change Major (2.1.0 > 3.0.0)
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)
2021-08-09 19:32:42 add fd2d1a6e-6d95-4df2-ad00-504bf0273406
JSON compare
compare mode: version left: version right:
JSON
api-version=2021-06-01