Ensure SQL server disables public network access

Error: SQL Server is enabled for public network access

Bridgecrew Policy ID: BC_AZR_NETWORKING_34
Checkov Check ID: CKV_AZURE_113
Severity: LOW

SQL Server is enabled for public network access

Description

By ensuring that your SQL server is not public, you can help protect your data from unauthorized access or tampering. Public SQL servers are accessible over the internet, which can make them vulnerable to external threats such as hackers or malware. By making it private, you can help ensure that only authorized users can access the data.

Fix - Buildtime

Terraform

  • Resource: azurerm_mssql_server
  • Argument: public_network_access_enabled
resource "azurerm_mssql_server" "example" {
              ...
 +            public_network_access_enabled = false
            }