Aqua CSPM

Open SQLServer

Quick Info

Plugin TitleOpen SQLServer
CloudAZURE
CategoryNetwork Security Groups
DescriptionDetermine if TCP port 1433 or UDP port 1434 for SQL Server is open to the public
More InfoWhile some ports such as HTTP and HTTPS are required to be open to the public to function properly, more sensitive services such as SQL server should be restricted to known IP addresses.
AZURE Linkhttps://docs.microsoft.com/en-us/azure/virtual-network/manage-network-security-group
Recommended ActionRestrict TCP port 1433 and UDP port 1434 to known IP addresses

Detailed Remediation Steps

  1. Log into the Microsoft Azure Management Console.
  2. Select the “Search resources, services, and docs” option at the top and search for Network security groups.
  3. Select the “Network security group” that needs to be verified.
  4. Click on the “Name” of the selected “Network security group” to access the port configurations.
  5. In the “Overview” tab scroll down the page and check the “Inbound security rules” under the “Settings”.
  6. If the “SQL Server” for port 1433/1434 with the protocol “TCP/UDP” is showing as “Allow” for all “Source” and “Destination” then the selected “Network security group” has TCP/UDP port 1433/1434 for “SQL Server” open to the public. <img src="/resources/azure/networksecuritygroups/open-sqlserver/step6.png)
  7. Repeat steps number 2 - 6 to verify other “Network security group.”
  8. Navigate to the “Network security group” and select the security group that needs to modify for restricting the “TCP/UDP” port for “SQL Server” on port 1433/1434 to specific IP Address. <img src="/resources/azure/networksecuritygroups/open-sqlserver/step8.png)
  9. Scroll down the left navigation panel and choose “Inbound security rules” under “Settings." <img src="/resources/azure/networksecuritygroups/open-sqlserver/step9.png)
  10. Click on the “SQL Server” protocol in the “Name” column and under “Source” select the “IP Address” from the dropdown menu and enter the “Source IP addresses/CIDR ranges” as per the requirement, select the required Protocol and Action and click on the “Save” option at the top panel. <img src="/resources/azure/networksecuritygroups/open-sqlserver/step10.png)
  11. Repeat steps number 8 - 10 to restrict TCP port 1433 and UDP port 1434 to known IP addresses.