Unrestricted inbound MSSQL access
Incident Management が一般に使用できるようになりました。 Incident Management が広範に使用できるようになりました。
<  Back to rules search

Unrestricted inbound MSSQL access

ec2

Classification:

compliance

Set up the ec2 integration.

このページは日本語には対応しておりません。随時翻訳に取り組んでいます。翻訳に関してご質問やご意見ございましたら、お気軽にご連絡ください。

Overview

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

  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