SQL Server should use Managed Identity

Medium Azure General sql-managed-identity

Applies to

Microsoft.Sql/servers

What CGPulse checks

A resource passes this rule when identity.type must be set. Anything else is reported as a finding with the evaluated property value attached as evidence.

How to fix it

Enable managed identity to eliminate stored credentials and improve security. In Azure Portal: SQL Server > Identity > enable System-assigned managed identity. See: https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal

CLI

az resource update --ids "{id}" --set identity.type=SystemAssigned

Terraform

resource "azurerm_mssql_server" "{name}" {
  name                         = "{name}"
  resource_group_name          = "{rg}"
  location                     = var.location
  version                      = "12.0"
  administrator_login          = "<admin-login>"
  administrator_login_password = "<admin-password>"
  identity {
    type = "SystemAssigned"
  }
}

Compliance frameworks

Cloud Security BaselineIM-1

Vendor documentation

Is your environment compliant with this rule?

CGPulse checks it — and 621 others — against your Azure and AWS accounts with read-only access.

Run a free scan