Azure

Harden Security Of Azure SQL Database: A Practical Hardening Guide

SQL Database Is Your Structured Data Core

Azure SQL Database holds structured transactional data — customer records, financial transactions, application state. Database security failures result in the most impactful breaches. Hardening Azure SQL means configuring network-level controls, enforcing Azure AD authentication, enabling Transparent Data Encryption with customer-managed keys, classifying sensitive data, and activating Advanced Threat Protection.

Threat Landscape and Attack Surface

Hardening Azure SQL Database requires understanding the threat landscape specific to this service. Azure services are attractive targets because they often store, process, or transmit sensitive data and provide control-plane access to cloud infrastructure. Attackers probe for misconfigured services using automated scanners that continuously sweep Azure IP ranges for exposed endpoints, weak authentication, and default configurations.

The attack surface for Azure SQL Database includes several dimensions. The network perimeter determines who can reach the service endpoints. The identity and access layer controls what authenticated principals can do. The data plane governs how data is protected at rest and in transit. The management plane controls who can modify the service configuration itself. A comprehensive hardening strategy addresses all four dimensions because a weakness in any single layer can be exploited to bypass the controls in other layers.

Microsoft’s shared responsibility model means that while Azure secures the physical infrastructure, network fabric, and hypervisor, you are responsible for configuring the service securely. Default configurations prioritize ease of setup over security. Every Azure service ships with settings that must be tightened for production use, and this guide walks through the critical configurations that should be changed from their defaults.

The MITRE ATT&CK framework for cloud environments provides a structured taxonomy of attack techniques that adversaries use against Azure services. Common techniques relevant to Azure SQL Database include initial access through exposed credentials or misconfigured endpoints, lateral movement through overly permissive RBAC assignments, and data exfiltration through unmonitored data plane operations. Each hardening control in this guide maps to one or more of these attack techniques.

Compliance and Regulatory Context

Security hardening is not just a technical exercise. It is a compliance requirement for virtually every regulatory framework that applies to cloud workloads. SOC 2 Type II requires evidence of security controls for cloud services. PCI DSS mandates network segmentation and encryption for payment data. HIPAA requires access controls and audit logging for health information. ISO 27001 demands a systematic approach to information security management. FedRAMP requires specific configurations for government workloads.

Azure Policy and Microsoft Defender for Cloud provide built-in compliance assessments against these frameworks. After applying the hardening configurations in this guide, run a compliance scan to verify your security posture against your applicable regulatory standards. Address any remaining findings to achieve and maintain compliance. Export compliance reports on a scheduled basis to satisfy audit requirements and demonstrate continuous adherence.

The Microsoft cloud security benchmark provides a comprehensive set of security controls mapped to common regulatory frameworks. Use this benchmark as a checklist to verify that your hardening effort covers all required areas. Each control includes Azure-specific implementation guidance and links to the relevant Azure service documentation.

Network Security

Private Endpoints

# Create private endpoint for SQL Server
az network private-endpoint create \
  --name pe-sql-prod --resource-group rg-networking \
  --vnet-name vnet-hub --subnet snet-private-endpoints \
  --private-connection-resource-id "/subscriptions/{subId}/resourceGroups/rg-data/providers/Microsoft.Sql/servers/sql-prod" \
  --group-id sqlServer --connection-name sql-pe-connection

# Disable public network access
az sql server update --name sql-prod --resource-group rg-data \
  --public-network-access Disabled

Firewall Rules

# If public access needed, allow only specific IPs
az sql server firewall-rule create --server sql-prod --resource-group rg-data \
  --name allow-office --start-ip-address 203.0.113.10 --end-ip-address 203.0.113.10

# DISABLE "Allow Azure services" (0.0.0.0 rule) — allows any Azure tenant
az sql server firewall-rule delete --server sql-prod --resource-group rg-data --name AllowAllWindowsAzureIps

The “Allow Azure services and resources to access this server” setting creates a 0.0.0.0 firewall rule that allows connections from ANY Azure subscription — not just yours. Disable it and use private endpoints or explicit VNet rules instead.

Authentication

Azure AD-Only Authentication

# Set Azure AD admin
az sql server ad-admin create --server sql-prod --resource-group rg-data \
  --display-name "DBA Team" --object-id "aad-group-object-id"

# Enable Azure AD-only authentication (disable SQL auth)
az sql server ad-only-auth enable --server sql-prod --resource-group rg-data

Azure AD-only authentication disables SQL login/password-based authentication entirely. All connections must use Azure AD tokens — including managed identities, service principals, and interactive login. This eliminates SQL password management, credential theft risk, and brute force attacks.

Application Access via Managed Identity

-- Grant database access to application managed identity
CREATE USER [webapp-prod] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [webapp-prod];
ALTER ROLE db_datawriter ADD MEMBER [webapp-prod];

-- For read-only reporting workloads
CREATE USER [reporting-func] FROM EXTERNAL PROVIDER;
ALTER ROLE db_datareader ADD MEMBER [reporting-func];

Identity and Access Management Deep Dive

Identity is the primary security perimeter in cloud environments. For Azure SQL Database, implement a robust identity and access management strategy that follows the principle of least privilege.

Managed Identities: Use system-assigned or user-assigned managed identities for service-to-service authentication. Managed identities eliminate the need for stored credentials (connection strings, API keys, or service principal secrets) that can be leaked, stolen, or forgotten in configuration files. Azure automatically rotates the underlying certificates, removing the operational burden of credential rotation.

Custom RBAC Roles: When built-in roles grant more permissions than required, create custom roles that include only the specific actions needed. For example, if a monitoring service only needs to read metrics and logs from Azure SQL Database, create a custom role with only the Microsoft.Insights/metrics/read and Microsoft.Insights/logs/read actions rather than assigning the broader Reader or Contributor roles.

Conditional Access: For human administrators accessing Azure SQL Database through the portal or CLI, enforce Conditional Access policies that require multi-factor authentication, compliant devices, and approved locations. Set session lifetime limits so that administrative sessions expire after a reasonable period, forcing re-authentication.

Just-In-Time Access: Use Azure AD Privileged Identity Management (PIM) to provide time-limited, approval-required elevation for administrative actions. Instead of permanently assigning Contributor or Owner roles, require administrators to activate their role assignment for a specific duration with a business justification. This reduces the window of exposure if an administrator’s account is compromised.

Service Principal Hygiene: If managed identities cannot be used (for example, for external services or CI/CD pipelines), use certificate-based authentication for service principals rather than client secrets. Certificates are harder to accidentally expose than text secrets, and Azure Key Vault can automate their rotation. Set short expiration periods for any client secrets and monitor for secrets that are approaching expiration.

Data Protection

Transparent Data Encryption (TDE) with CMK

# Configure TDE with customer-managed key
az sql server tde-key set --server sql-prod --resource-group rg-data \
  --server-key-type AzureKeyVault \
  --kid "https://kv-prod.vault.azure.net/keys/sql-tde-key/version"

Data Classification and Discovery

# Enable data discovery and classification
az sql db classification recommendation list \
  --server sql-prod --resource-group rg-data --name appdb

# Apply recommended classifications
az sql db classification recommendation enable \
  --server sql-prod --resource-group rg-data --name appdb \
  --schema dbo --table Customers --column Email

Data classification labels sensitive columns (PII, financial, health data) and enables auditing policies that specifically track access to classified data.

Dynamic Data Masking

-- Mask email addresses for non-admin users
ALTER TABLE Customers ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()');

-- Mask credit card numbers
ALTER TABLE Payments ALTER COLUMN CardNumber ADD MASKED WITH (FUNCTION = 'partial(0,"XXXX-XXXX-XXXX-",4)');

Always Encrypted

For data that should never be visible to database administrators, use Always Encrypted. Columns are encrypted using keys stored in Key Vault or Windows Certificate Store. The database engine never sees plaintext values — encryption and decryption happen exclusively in the client driver.

Auditing and Threat Detection

# Enable auditing to Log Analytics
az sql server audit-policy update --server sql-prod --resource-group rg-data \
  --state Enabled \
  --lats Enabled \
  --lawri "/subscriptions/{subId}/resourceGroups/rg-monitoring/providers/Microsoft.OperationalInsights/workspaces/law-prod"

# Enable Advanced Threat Protection
az sql server threat-policy update --server sql-prod --resource-group rg-data \
  --state Enabled \
  --email-addresses security@contoso.com \
  --email-account-admins true

Advanced Threat Protection detects SQL injection attempts, anomalous access patterns (unusual client IPs, brute force), data exfiltration signals, and potential vulnerabilities.

Vulnerability Assessment

# Enable vulnerability assessment
az sql va server baseline set --server sql-prod --resource-group rg-data \
  --workspace-id law-prod-workspace-id

Vulnerability Assessment scans databases for security misconfigurations (excessive permissions, missing audit policies, unmasked sensitive data) and provides remediation recommendations.

Defense in Depth Strategy

No single security control is sufficient. Apply a defense-in-depth strategy that layers multiple controls so that the failure of any single layer does not expose the service to attack. For Azure SQL Database, this means combining network isolation, identity verification, encryption, monitoring, and incident response capabilities.

At the network layer, restrict access to only the networks that legitimately need to reach the service. Use Private Endpoints to eliminate public internet exposure entirely. Where public access is required, use IP allowlists, service tags, and Web Application Firewall (WAF) rules to limit the attack surface. Configure network security groups (NSGs) with deny-by-default rules and explicit allow rules only for required traffic flows.

At the identity layer, enforce least-privilege access using Azure RBAC with custom roles when built-in roles are too broad. Use Managed Identities for service-to-service authentication to eliminate stored credentials. Enable Conditional Access policies to require multi-factor authentication and compliant devices for administrative access.

At the data layer, enable encryption at rest using customer-managed keys (CMK) in Azure Key Vault when the default Microsoft-managed keys do not meet your compliance requirements. Enforce TLS 1.2 or higher for data in transit. Enable purge protection on any service that supports soft delete to prevent malicious or accidental data destruction.

At the monitoring layer, enable diagnostic logging and route logs to a centralized Log Analytics workspace. Configure Microsoft Sentinel analytics rules to detect suspicious access patterns, privilege escalation attempts, and data exfiltration indicators. Set up automated response playbooks that can isolate compromised resources without human intervention during off-hours.

Continuous Security Assessment

Security hardening is not a one-time activity. Azure services evolve continuously, introducing new features, deprecating old configurations, and changing default behaviors. Schedule quarterly security reviews to reassess your hardening posture against the latest Microsoft security baselines.

Use Microsoft Defender for Cloud’s Secure Score as a quantitative measure of your security posture. Track your score over time and investigate any score decreases, which may indicate configuration drift or new recommendations from updated security baselines. Set a target Secure Score and hold teams accountable for maintaining it.

Subscribe to Azure update announcements and security advisories to stay informed about changes that affect your security controls. When Microsoft introduces a new security feature or changes a default behavior, assess the impact on your environment and update your hardening configuration accordingly. Automate this assessment where possible using Azure Policy to continuously evaluate your resources against your security standards.

Conduct periodic penetration testing against your Azure environment. Azure’s penetration testing rules of engagement allow testing without prior notification to Microsoft for most services. Engage a qualified security testing firm to assess your Azure SQL Database deployment using the same techniques that real attackers would employ. The findings from these tests often reveal gaps that automated compliance scans miss.

Hardening Checklist

  1. Network: Private endpoints; disable public access; remove 0.0.0.0 firewall rule
  2. Authentication: Azure AD-only authentication; managed identity for applications
  3. Encryption: TDE with customer-managed keys; Always Encrypted for sensitive columns
  4. Data protection: Data classification and discovery; dynamic data masking
  5. TLS: Minimum TLS 1.2 (default)
  6. Auditing: Server audit to Log Analytics; audit classified data access
  7. Threat protection: Advanced Threat Protection enabled; email alerts configured
  8. Assessment: Vulnerability Assessment enabled with baseline
  9. Least privilege: Database roles with minimal permissions per application

For more details, refer to the official documentation: What is Azure SQL Database?, Azure SQL Database and Azure Synapse IP firewall rules, Troubleshoot connectivity issues and other errors.

Leave a Reply