A security group is a stateful virtual firewall capable of filtering. As an important means for network security isolation provided by Tencent Cloud, it can be used to set network access controls for one or more TencentDB instances. Instances with the same network security isolation demands in one region can be put into the same security group, which is a logical group. TencentDB and CVM share the security group list and are matched with each other within the security group based on rules. For specific rules and limitations, see Security Group Overview.
- TencentDB for SQL Server security group currently only supports network access control for VPCs and public network but not the classic network.
- Security groups that currently support public network access are available only in Guangzhou, Shanghai, Beijing, and Chengdu.
- As TencentDB doesn’t have any active outbound traffic, outbound rules don’t apply to it.
- TencentDB for SQL Server security group supports primary and read-only instances.
Configuring Security Groups for TencentDB
Step 1. Create a security group
- Log in to the CVM console.
- Select Security Group on the left sidebar, select a region, and click Create.
- In the pop-up dialog window, configure the following items, and click OK.
- Template: Select a template based on the service to be deployed on the TencentDB instance in the security group, which simplifies the security group rule configuration.
|Open all ports||All ports are opened to the public and private networks. This may expose your database instances to security threats.||-|
|Open ports 22, 80, 443, and 3389 and the ICMP protocol||Ports 22, 80, 443, and 3389 and the ICMP protocol are opened to the internet. All ports are opened to the private network.||This template does not take effect for TencentDB.|
|Custom||You can create a security group and then add custom rules. For detailed directions, see "Step 2. Add a security group rule" below.||-|
- Name: Custom name of the security group.
- Project: Select a project for easier management. By default, DEFAULT PROJECT is selected.
- Notes: A short description of the security group for easier management.
Step 2. Add a security group rule
- On the Security Group page, click Modify Rule in the Operation column on the row of the security group for which to configure a rule.
- On the security group rule page, click Inbound Rules > Add Rule.
- In the pop-up dialog box, set the rule.
- Type: "Custom" is selected by default. You can also choose another system rule template. “SQL Server(1433)” is recommended.
- Source or Target: Traffic source (inbound rules) or target (outbound rules). You need to specify one of the following options:
|Source or Target||Description|
|A single IPv4 address or an IPv4 range||In CIDR notation, such as |
0.0.0.0/0 indicates all IPv4 addresses will be matched.
|A single IPv6 address or an IPv6 range||In CIDR notation, such as |
0::0/0 indicates all IPv6 addresses will be matched.
|ID of referenced security group. You can reference the ID of:|
- Current security group
- Other security group
- Current security group: CVMs associated with the current security group.
- Other security group: ID of another security group in the same region that belongs to the same project.
|Reference an IP address object or IP address group object in a parameter template.||-|
- Protocol Port: Enter the protocol type and port range or reference a protocol/port or protocol/port group in a parameter template management.
To connect to TencentDB for SQL Server, port 1433 must be opened.
- Policy: Allow or Reject. Allow is selected by default.
- Allow: Traffic to this port is allowed.
- Reject: Data packets will be discarded without any response.
- Notes: A short description of the rule for easier management.
- Click Complete.
Scenario: You have created a TencentDB for SQL Server instance and want to access it from a CVM instance.
Solution: When adding security group rules, select SQL Server(1433) in "Type" to open port 1433.
You can also set Source to all or specific IPs (IP ranges) as needed to allow them to access TencentDB for SQL Server from a CVM instance.
|Inbound or Outbound
||Protocol and Port
||All IPs: 0.0.0.0/0
Specific IPs: Specify IPs or IP ranges
Step 3. Configure a security group
A security group is an instance-level firewall provided by Tencent Cloud for controlling inbound traffic of TencentDB. You can associate a security group with an instance when purchasing it or later in the console. The operations for configuring security groups in two scenarios are as detailed below:
Currently, security groups can be configured only for TencentDB for SQL Server instances in VPC.
After the security group is created, you can associate a security group with an instance when purchasing it, and also you can quickly locate the target group by multiple selection and fuzzy search.
- Log in to TencentDB for SQL Server purchase page.
- Click the parameter Security Group>Existing Security Group, and select the target security group in the box. Multiple selection and fuzzy search are supported for quickly locating the target group.
- After setting all the parameters, click Buy Now.
You can delete the redundant associated security groups after selecting multiple of them. At least one security group is reserved by default.
Scenario 2: Associate a security group with an instance after purchasing it in the console
- Log in to the TencentDB for SQL Server Console. In the instance list, select the instance for which to configure a security group and click Manage in the "Operation" column to enter the instance management page.
- Select Security Group ** tab, and click **Configure Security Group
- In the pop-up dialog box, select the security group to be bound and click OK.
Importing Security Group Rules
- On the Security Group page, click the ID/name of the desired security group.
- On the inbound rule or outbound rule tab, click Import Rule.
- In the pop-up dialog box, select an edited inbound/outbound rule template file and click Import.
As existing rules will be overwritten after importing, we recommend that you export the existing rules before importing new ones.
Cloning Security Groups
- On the Security Group page, locate the desired security group and click More > Clone in the Operation column.
- In the pop-up dialog box, select the target region and target project, enter the new security group name, and click OK. If the new security group needs to be associated with a CVM instance, do so by managing the CVM instances in the security group.
Deleting Security Groups
- On the Security Group page, locate the security group to be deleted and click More > Delete in the Operation column.
- Click OK in the pop-up dialog box. If the current security group is associated with a CVM instance, it must be disassociated before it can be deleted.