Inbound MSSQL access should be restricted

ec2
이 페이지는 아직 한국어로 제공되지 않으며 번역 작업 중입니다. 번역에 관한 질문이나 의견이 있으시면 언제든지 저희에게 연락해 주십시오.

Description

Reduce the probability of a breach by checking EC2 security groups for inbound rules that allow unfettered access to TCP port 1433 (used by the Microsoft SQL Server) and restrict access to IP addresses that require this port.

Rationale

Malicious activity, such as denial-of-service (DoS) attacks and hacking, can occur when permitting unfettered access to this port.

Remediation

From the console

Follow the Security group rules docs to learn how to add a security group rule that will restrict access to a specific port.

From the command line

  1. Run revoke-security-group-ingress to remove inbound rules that allow unrestricted access to port 1433.

    revoke-security-group-ingress.sh

        aws ec2 revoke-security-group-ingress
        --group-name group-name
        --protocol tcp
        --port 1433
        --cidr 192.0.2.0/24

  2. Run authorize-security-group-ingress to add new inbound rules that restrict port 1433 access.

    revoke-security-group-ingress.sh

        aws ec2 authorize-security-group-ingress
        --group-name your-group-name
        --protocol tcp
        --port 1433
        --cidr 192.0.2.0/24