AI CloudAdvisor (Beta)

My Presets

You must be logged in to save or view your saved configuration templates

Security Controls

Service Control PoliciesConfig RulesCloudWatch Alarms and Event RulesCloudFormation Guard RulesLogging & Monitoring ConfigurationsBackups & DRAuto Remediation RulesConformance PacksBilling and Cost ManagementS3 Bucket PoliciesSecurity Groups & NACLsIAM PoliciesVPC Endpoint Policies

AWS Services

Guided Walkthroughs

Configuration Packages

Reference Guides

Other

AI CloudAdvisor (Beta)

Configuration Stack
0

My Presets

Security Controls

AWS Services

Guided Walkthroughs

Configuration Packages

Reference Guides

Other

Security Groups & NACLs

Microsoft SQL Server Security Group

A security group that allows inbound access to a Microsoft SQL server instance.

The template creates the security group into an existing VPC, and requires the following details: 

  • VPC ID: Provide the VPC ID to create the security group in.
  • Security Group Rules: Click on 'Customize Rules' and enter the missing rule information (Source IP, Prefix List or Security Group, Port number, and Protocol) depending on the security group template. 

See Related Items section for configuration templates to create a new VPC.

Try out CloudAdvisor: Your AI-Powered Assistant for AWS Cloud

Items
1
Size
0.7 KB
Missing Parameters
AWSTemplateFormatVersion: '2010-09-09'
Description: ''
Resources:
  SecurityGroup:
    Type: 'AWS::EC2::SecurityGroup'
    Properties:
      GroupDescription: A security group that allows inbound access to a Microsoft SQL server instance.
      VpcId: ''
      SecurityGroupEgress:
        - FromPort: -1
          ToPort: -1
          IpProtocol: '-1'
          Description: ''
          CidrIp: 0.0.0.0/0
      SecurityGroupIngress:
        - FromPort: 1433
          ToPort: 1433
          IpProtocol: tcp
          Description: Allow connections to a Microsoft SQL server
          CidrIp: ''
      GroupName: allow-mssql-traffic
Parameters: {}
Metadata: {}
Conditions: {}

Actions



Customize Template

 
* Required field

Upgrade to Premium for More Features
Sign up

Guided Walkthroughs
Step-by-step configuration wizards for your environment
Dedicated Security Account
AWS Backup Strategy
VPC Connectivity Setup
Automated Patching
All Guides
Configuration Packages
Pre-built packages for common configuration
Common SCPs
CloudFormation Guard Rules
Auto Remediation Rules
IAM Monitoring & Compliance
All Packages
Automated Assessments
  • 350+ security checks
  • Well-architected reviews
  • Detailed compliance reports
  • Remediation templates
  • Email summaries
  • Learn more