last sync: 2024-Oct-11 17:51:49 UTC

Azure SQL Managed Instance should have Microsoft Entra-only authentication

Azure BuiltIn Policy Initiative (PolicySet)

Source Azure Portal
Display nameAzure SQL Managed Instance should have Microsoft Entra-only authentication
Id9b8d8228-e8cc-4c95-8d98-47f32df40b5e
Version1.0.0
Details on versioning
Versioning Versions supported for Versioning: 1
1.0.0
Built-in Versioning [Preview]
CategorySQL
Microsoft Learn
DescriptionRequire Microsoft Entra-only authentication for Azure SQL Managed instance, disabling local authentication methods. This allows access exclusively via Microsoft Entra identities, enhancing security with modern authentication enhancements including MFA, SSO, and secret-less programmatic access with managed identities.
TypeBuiltIn
DeprecatedFalse
PreviewFalse
Policy count Total Policies: 2
Builtin Policies: 2
Static Policies: 0
Policy used
Policy DisplayName Policy Id Category Effect Roles# Roles State
Azure SQL Managed Instance should have Microsoft Entra-only authentication enabled 0c28c3fb-c244-42d5-a9bf-f35f2999577b SQL Default
Audit
Allowed
Audit, Deny, Disabled
0 GA
Azure SQL Managed Instances should have Microsoft Entra-only authentication enabled during creation 78215662-041e-49ed-a9dd-5385911b3a1f SQL Default
Audit
Allowed
Audit, Deny, Disabled
0 GA
Roles used No Roles used
History
Date/Time (UTC ymd) (i) Changes
2024-01-29 19:36:15 add Initiative 9b8d8228-e8cc-4c95-8d98-47f32df40b5e
JSON compare n/a
JSON
api-version=2021-06-01
EPAC