VPC security group rules should not permit ingress from ‘0.0.0.0/0’ to TCP/UDP port 2383 (SQL Server Analysis Services)¶
Description¶
VPC security group rules should not permit ingress from ‘0.0.0.0/0’ to TCP/UDP port 2383 (SQL Server Analysis Services). Removing unfettered connectivity to a SQL Server Analysis Services server reduces the chance of exposing critical data.
Console Remediation Steps¶
Navigate to VPC.
In the left pane, click Security Groups.
For each security group, perform the following:
Select the security group.
Click the Inbound Rules tab.
Identify the rules to be removed.
Click the x in the Remove column.
Click Save.
CLI Remediation Steps for TCP¶
Remove the inbound rule(s) that permits unrestricted ingress to TCP port 2383 from the selected Security Group:
aws ec2 revoke-security-group-ingress --region <region> --group-name <group_name> --protocol tcp --port 2383 --cidr 0.0.0.0/0
Optionally add a more restrictive ingress rule to the selected Security Group:
aws ec2 authorize-security-group-ingress --region <region> --group-name <group_name> --protocol tcp --port 2383 --cidr <cidr_block>
CLI Remediation Steps for UDP¶
Remove the inbound rule(s) that permits unrestricted ingress to UDP port 2383 from the selected Security Group:
aws ec2 revoke-security-group-ingress --region <region> --group-name <group_name> --protocol udp --port 2383 --cidr 0.0.0.0/0
Optionally add a more restrictive ingress rule to the selected Security Group:
aws ec2 authorize-security-group-ingress --region <region> --group-name <group_name> --protocol udp --port 2383 --cidr <cidr_block>