Remove entries in security group which allows MSSQL(TCP port 1433) access from public IP.

24 Times Used
22 MAY 2019

It is AWS best practice to remove entries in security group which allows MSSQL access from public IP to reduce possibility of breach. Allowing unrestricted MSSQL access can increase threats like hacking, denial-of-service (DoS) attacks and loss of data.

Workflow Template

Gets Security Groups in a specific AWS Region for EC2 service.
Provide your details to emulate workflow
Fulfils organizational obligation(if any) before taking any action on an AWS resource.
Provide your details to emulate workflow

Trigger

Use this to initiate a workflow based on time, events or HTTP calls.

Resource

Select resources on which you want to work on.

Filter

Enter parameters to filter resources in the workflow.

User Approval

Use this to get approval from stakeholder to continue the workflow.

Action

Select action to be done on resources in the workflow.

Filters the Security Groups which allow MSSQL (TCP port 1433) from public IP
Provide your details to emulate workflow
Revoke Security Group Ingress in a specific AWS Region for EC2 service.
Provide your details to emulate workflow
Use Template