Confirm the configuration info. Then, read and indicate your consent to the Terms of Service, confirm that everything is correct, and click Buy Now.
Step 1. Select a basic configuration
In this step, you can set the basic configuration and specification options for the instance. The specific settings are as follows:
Basic Configuration
Billing Mode: Pay-as-you-go.
Region: We recommend that you choose the region closest to your end users to minimize access latency and improve download speed.
AZ: Select an AZ in the selected region. You can also use the AZ that is randomly allocated by the system.
Instance Architecture: The instance is on a single-node or two-node architecture.
Storage Type:
When single-node architecture is selected, you can choose from premium cloud disk, SSD, balanced SSD, and enhanced SSD.
Note:
In the Chinese mainland, if you need SSD for your basic edition instances, submit a ticket for application.
When two-node architecture is selected, you can choose from enhanced SSD, balanced SSD, and high-performance local SSD.
For a detailed description of each storage type and applicable scenarios, see Storage Types.
Database Version: supports SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 and SQL Server 2019 Enterprise and Standard version as well as SQL 2022 Enterprise version.
Specs Configuration
Type: The Dedicated type is supported.
Filter: You can quickly filter the needed CPU and memory specifications for the instance. By default, all CPU and memory specifications are selected.
Selected instances: The specification information of the selected instances are displayed, including specification type and specification.
Instance Specifications: The detailed specification information is displayed, including the specification type, CPU, memory, maximum IOPS, supported AZs, and reference fees.
Storage Space: Select the required disk capacity.
Step 2. Set network and database
Network: VPC is supported. For connectivity testing, see Network Environment. Both VPCs and subnets support fuzzy search.
Note:
We recommend that you place the CVM and TencentDB instances under the same account in the same VPC in the same region.
A subnet is a logical network space in a VPC. You can create subnets in different AZs in the same VPC, which communicate with each other over the private network by default. Even if you select a subnet in another AZ in the same region, the network latency will not be increased because the actual business connection adopts nearby access.
Security Group: 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.
Note:
You can either create new security groups or choose from existing ones. You can also locate the target group by fuzzy search.
Instance Name: Select Set After Creation or Set Now.
Multi-AZ Deployment: If Yes is selected, it means that the multi-AZ Deployment is set, and the backup AZ should be selected in the next step; if No is selected, it indicates that there is no need to perform the multi-AZ deployment. The multi-AZ is a physical zone integrating multiple single-AZs in the same region at the single AZ level to protect the database from the potential instance failure or AZ interruption.
Replica AZ: After multi-AZ deployment is selected, you need to select the replica AZ based on the actual optional resources.
System Time Zone: China Standard Time (Beijing Time) is supported by default.
For the purchase of the two-node local disk instances, submit a ticket to apply for the modification of the system time zone.
For the purchase of the single-node cloud disk or two-node cloud disk instances, the system time zone can be directly modified without application.
Sorting Rules of Character Set: The instance character set provides sorting rules for system data, namely, distinguishing between case-sensitive attributes and accent attributes. The Chinese_PRC_CI_AS is supported by default.
If a two-node local disk instance is purchased, submit a ticket to apply for the modification of the rules for the character set.
If a single-node cloud disk or two-node cloud disk instance is purchased, the rules can be modified directly without application.
Project: TencentDB for SQL Server supports assigning instances to different projects for management. You can perform fuzzy search for projects by name.
Tag: You can use tags to easily categorize and manage resources. You are allowed to add multiple tags.
Maintenance Window/Maintenance Time: The backend system performs maintenance operations on your TencentDB for SQL Server instance from time to time to ensure its stability. To minimize the potential impact on your business, we recommend that you set an acceptable maintenance period for your business instance, usually during off-peak hours. You can select up to all the seven options for the maintenance windows.
Step 3. Confirm the configuration info
Display the instance configuration details in Step 1 and Step 2. Click Edit directly in case of modification. After confirmation of the result, read and check Terms of Service, and then click on Buy Now.
Terms of Service: For more information, see Terms of Service.
2. Return to the Instance List after purchase and view the created instances. When the instance status is Running, the instance is successfully created.
Creating an account
1. In the instance list, click an instance ID or Manage in the Operation column to enter the instance management page.
2. On the instance management page, select Account Management > Create Account and enter relevant information in the pop-up window. After confirming that everything is correct, click OK.
Note:
The created account name and password will be used when connecting to TencentDB for SQL Server. Store them properly.
Creating a database
1. In the instance list, click an instance ID or Manage in the Operation column to enter the instance management page.
2. On the Instance Management page, select Database Management > Create Database, set configuration items in the pop-up window, confirm that everything is correct, and click OK.
Database Name: It can contain up to 32 letters, digits, and underscores and must start with a letter.
Character Set: Select the character set to be used by the database. Currently, most native character sets are supported.
Authorize Account: You can authorize existing accounts to access the database. If you haven't created an account yet, see Creating an account.
Yes
No
Was this page helpful?