Homepage
About Snyk

SQL Server Active Directory Admin is not configured Affecting Database service in Azure

0.0
medium
0
10
    Severity Framework Snyk CCSS
    Rule category IAM / Usage

Is your enviroment affected by this misconfiguration?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications
    Frameworks
    CIS-Azure
  • Snyk ID SNYK-CC-00702
  • credit Snyk Research Team
Report a new misconfiguration Found a mistake?

Description

Azure Active Directory authentication for SQL Database uses Azure AD identities, providing an alternative to SQL Server authentication. This helps centralize permission management, reduces proliferation of identities, and eliminates the need to store more passwords.

How to fix?

SQL Server Active Directory Admin should be configured.

Example Configuration

{
    "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
    "contentVersion": "1.0.0.0",
    "resources": [
      {
        "type": "Microsoft.Sql/servers",
        "apiVersion": "2020-02-02-preview",
        "name": "allowed702",
        "location": "West Europe",
        "properties": {
          "administratorLogin": "4dm1n157r470r",
          "administratorLoginPassword": "4-v3ry-53cr37-p455w0rd",
          "version": "12.0"
        }
      },
      {
        "type": "Microsoft.Sql/servers/administrators",
        "apiVersion": "2020-02-02-preview",
        "name": "allowed702/activeDirectory",
        "location": "West Europe",
        "dependsOn": [
        "[resourceId('Microsoft.Sql/servers', 'allowed702')]"
        ],
        "properties": {
          "administratorType": "ActiveDirectory",
          "login": "sqladmin",
          "sid": "19f30f3a-1b04-4a63-99d3-fc482217efba",
          "tenantId": "[subscription().tenantId]"
        }
      },
        ]
  }