AD Admin Not Configured For SQL Server

• Query id: b176e927-bbe2-44a6-a9c3-041417137e5f
• Query name: AD Admin Not Configured For SQL Server
• Platform: Ansible
• Severity: High
• Category: Insecure Configurations
• URL: Github

Description

The Active Directory Administrator is not configured for a SQL server
Documentation

Code samples

Code samples with security vulnerabilities

Positive test num. 1 - yaml file

---
- name: Create (or update) SQL Server
  azure_rm_sqlserver:
    resource_group: myResourceGroup
    name: server_name
    location: westus
    admin_username: mylogin
    admin_password: Testpasswordxyz12!

Code samples without security vulnerabilities

Negative test num. 1 - yaml file

- name: Create (or update) SQL Server
  azure_rm_sqlserver:
    resource_group: myResourceGroup
    name: server_name
    location: westus
    admin_username: mylogin
    admin_password: Testpasswordxyz12!
    ad_user: sqladmin