last sync: 2024-Nov-25 18:54:24 UTC

[Deprecated]: Configure Arc-enabled machines running SQL Server to have SQL Server extension installed.

Azure BuiltIn Policy definition

Source Azure Portal
Display name [Deprecated]: Configure Arc-enabled machines running SQL Server to have SQL Server extension installed.
Id fd2d1a6e-6d95-4df2-ad00-504bf0273406
Version 3.4.1-deprecated
Details on versioning
Versioning Versions supported for Versioning: 2
3.4.0
3.4.1 (3.4.1-deprecated)
Built-in Versioning [Preview]
Category SQL
Microsoft Learn
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 the SQL Server extension installed. This policy is deprecated because we are migrating to a more streamlined. recommended and automated process of onboarding Arc Servers with SQL installed onto the Azure extension for SQL Server. Learn more about the auto-onboarding process at https://aka.ms/SQLServerExtensionPolicyDeprecation
Mode Indexed
Type BuiltIn
Preview False
Deprecated True
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 Path PathIsDefault DefaultPath Modifiable
Microsoft.HybridCompute/machines/mssqlDiscovered Microsoft.HybridCompute machines properties.mssqlDiscovered True False
THEN-ExistenceCondition (3)
Alias Namespace ResourceType Path PathIsDefault DefaultPath Modifiable
Microsoft.HybridCompute/machines/extensions/provisioningState Microsoft.HybridCompute machines/extensions properties.provisioningState True False
Microsoft.HybridCompute/machines/extensions/publisher Microsoft.HybridCompute machines/extensions properties.publisher True False
Microsoft.HybridCompute/machines/extensions/type Microsoft.HybridCompute machines/extensions properties.type True 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
2024-02-20 22:44:08 change Patch, new suffix: deprecated (3.4.0 > 3.4.1-deprecated)
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
EPAC