Public SQL Server

Ensure that the TCP port 1433 or UDP port 1434 for the SQL (Structured Query Language) server is not open to public

Risk Level: High

Description

This plugin determines if the TCP port 1433 or UDP port 1434 for the SQL (Structured Query Language) server is open to the public. Unlike HTTP and HTTPS, which can be available to public access, SQL servers must be restricted to known IP addresses. These ports are used by the SQL servers for establishing connections with the SQL database instance.

To minimize false positives, this plugin reports only those security groups with public IP associated with any of its network interfaces.

About the Service

Amazon EC2: Amazon Elastic Compute Cloud (Amazon EC2) provides scalable computing capacity in the Amazon Web Services (AWS) Cloud. With the EC2 instance, you can launch as many virtual servers as you need, configure security and networking, and manage storage without worrying about the hardware needs of the process. Security Groups act as a firewall for an EC2 instance to control the incoming and outgoing traffic. You can read more about security groups here.

Impact

Security Groups act as a firewall for the EC2 instances to control the incoming and outgoing traffic. There are rules defined under security groups that can allow specific IP addresses to access the EC2 instance with the protocol and the Ports specified.

TCP port 1433 is used SQL servers to connect with the Database instance whereas UDP port 1434 allows automatic discovery of SQL workstations. In a secure infrastructure, these ports must be accessible to only trusted IPs. Open SQL ports provide a pathway for attackers to exploit the application.

Steps to Reproduce

Using AWS Console-

  1. Log In to your AWS Console.
  2. Open the EC2 Management Console. You can use this link (https://console.aws.amazon.com/ec2) to navigate directly if already logged in. 
  3. Move to the Security Group in the Network and Security section from the left navigation pane.
  4. You will find a list of Security Groups available. In the Filter security groups bar type Protocol: TCP and Protocol: UDP to filter out all the security groups having rules for the mentioned protocol. From the list of security groups, choose one by clicking on its Security group ID.
  5. The Inbound rules tab will be selected which has a list of rules for the security group. Investigate the Source column, and find the rules that have the source set to Anywhere (0.0.0.0/0 or ::/0). Similarly, find if the Port is set to 1433 with the Protocol TCP or the port is set to 1434 with the Protocol UDP. It implies that the instances and resources attached to the security group can accept public requests.
  6. Repeat steps 4 to 5 for all the Security Groups you want to investigate.

Steps for Remediation

Modify the security group and permit only required IP addresses to access the SQL server:

  1. Log In to your AWS Console.
  2. Open the EC2 Management Console. You can use this link (https://console.aws.amazon.com/ec2) to navigate directly if already logged in. 
  3. Move to the Security Group in the Network and Security section from the left navigation pane.
  4. You will find a list of Security Groups available. In the Filter security groups bar type Protocol: TCP and Protocol: UDP to filter out all the security groups having rules for the mentioned protocol. From the list of security groups, choose one by clicking on its Security group ID.

  5. The Inbound rules tab will be selected along with a list of rules for the security group. Click on the Edit Inbound Rules button on the right.
  6. From the list of rules with TCP Protocol and Port 1433 or UDP Protocol and Port 1434, click on the close button beside the (0.0.0.0/0 or ::/0) in the Source column. It will clear all the IP addresses allowed to access the instance. From the Source drop-down menu, select Custom and enter all the IP addresses you want to give access to following the protocol.
  7. To allow only your IP to access the instance, select the My IP option. You can read more about all the options available here.
  8. Click on Preview Changes to preview the changes, and Save rules to save them.
  9. Repeat steps 4 to 8 for all the Security Groups you want to fix.