RDS for SQL Server
Category | Parameter | Description |
- | Database type | Select Microsoft SQL Server. |
Basic information | Instance name | (Optional) Set an instance name. The naming rules are as follows:
tip If you do not enter an instance name, it will be the same as the instance ID. |
| Compatible versions | You can select SQL Server 2019 Standard Edition, SQL Server 2019 Enterprise Edition, SQL Server 2019 Web Edition, SQL Server 2022 Standard Edition, SQL Server 2022 Enterprise Edition, SQL Server 2022 Web Edition. tip To create instances of SQL Server 2025 Standard Edition and SQL Server 2025 Enterprise Edition, submit a ticket to the SQL Server technical team to be added to the allowlist. This feature is currently available on an allowlist. |
Specification configuration | Instance type | Select an instance type as needed. The supported types are as follows: High availability, Single node edition, and Cluster edition.
|
| Specification family | Optional: Select the Include previous generations radio button to choose a specification type that includes previous generations in the Specification type section. tip When the selected Compatible version is later than SQL Server 2022 , the 1ie specification family of historical generation specifications is not supported. |
| Specification type | The specification type is Exclusive Type by default. If you click the Include previous generation specifications radio button above:
tip |
| Node specification | Configure the node specifications and availability zones for the instance's primary and secondary nodes as needed. The details are as follows:
tip
tip
|
| Storage Type | Only Extremely-Fast SSD PL1 Cloud Disk is currently supported. |
| Storage space | Storage space includes data file space and temporary file space. Enter a storage space between 20 GiB and 4000 GiB in 10 GiB increments. Select a value based on your business needs. tip |
Network configuration | VPC | Select the VPC for the instance from the dropdown list. You can also click Create VPC on the right to create a VPC. For more information, see Create a VPC. tip VPC stands for Virtual Private Cloud. A VPC is an isolated network environment that offers higher security and better performance than a traditional classic network. |
| Subnet | The subnets vary depending on the availability zones selected for the primary and secondary nodes, as follows:
tip A subnet is a block of IP addresses within a VPC. All cloud resources in the VPC must be deployed in a subnet. The subnet assigns private IP addresses to cloud resources. For more information, see Create a subnet. |
| Allowlist | Associate an allowlist with the instance. Click the allowlist text box to go to the Associate allowlist page. On this page, select an allowlist and click Confirm. You will return to the Create instance page, and the selected allowlist will appear in the allowlist text box. tip
|
Account configuration | Super account | The system selects veyun_user by default and this cannot be modified. |
| Super account password | Set the password for the super account. The requirements are as follows:
|
| Confirm password | Enter the password again. |
Advanced configuration | Time zone | The only supported time zone is (UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi. |
| Instance character set | Select the character set for the instance database. Supported options include Chinese_PRC_90_CI_AI, Chinese_PRC_BIN, Chinese_PRC_BIN2, Chinese_PRC_CI_AI, Chinese_PRC_CI_AS, Chinese_PRC_CS_AS, Chinese_Taiwan_Stroke_CI_AS, Chinese_Taiwan_Stroke_CS_AS, Cyrillic_General_CI_AS, Japanese_CI_AS, Japanese_CS_AS, Latin1_General_100_CI_AS_SC_UTF8, Latin1_General_CI_AS, Latin1_General_CS_AS, SQL_Latin1_General_CP1_CI_AS, SQL_Latin1_General_CP1_CS_AS, and Thai_CI_AS. The default is Chinese_PRC_CI_AS. tip
|
| Maintenance window | Confirm the maintenance window for the instance. To modify, click Modify. In the Modify maintenance period dialog box, set the Maintenance window and click OK. tip
|
| Project | Select a project for this instance from the dropdown list. The default project is default. You can also click Create new project to create a new project. For detailed instructions, see Create a new project. tip A project is a virtual concept that includes a set of resources, users, and roles. Projects allow you to centrally view and manage a group of resources and control the permissions of users and roles on these resources within the project. For more information, see Resource Management. |
| Tag | (Optional) Add tags to the instance. tip Tags help identify and categorize cloud resources. RDS for SQL Server lets you add tags to instances for classification, simplifying instance searches and resource aggregation. For more information, see Tag overview. |
Billing information | Billing methods | You can select either pay-as-you-go or subscription. If you select subscription, you need to set the subscription duration. You can also select auto-renewal, and the system will automatically renew the instance before it expires. tip You can also create a pay-as-you-go instance and switch to a subscription after confirming it meets your requirements. For more billing information, see Billing overview. |
- | Quantity | Select the number of instances to create in the lower-left corner of the page. You can create up to 10 instances in a batch. tip By default, each Volcano Engine primary account can purchase up to 30 instances in each region. If you need to increase your quota to purchase more instances, go to the Quota Center to submit a Quota application. |
Instance character set | Description |
Chinese_PRC_90_CI_AI | Chinese-PRC (Simplified Chinese), case-insensitive, accent-insensitive (compatible with SQL Server 2005). |
Chinese_PRC_CI_AI | Chinese-PRC (Simplified Chinese), case-insensitive, accent-insensitive. |
Chinese_PRC_CI_AS | Chinese-PRC (Simplified Chinese), case-insensitive, accent-sensitive. |
Chinese_PRC_CS_AS | Chinese-PRC (Simplified Chinese), case-sensitive, accent-sensitive. |
Chinese_PRC_BIN | Chinese-PRC (Simplified Chinese), binary comparison, case-sensitive, and accent-sensitive. |
Chinese_PRC_BIN2 | Chinese-PRC (Simplified Chinese), binary comparison, case-sensitive, and accent-sensitive. BIN2 provides more accurate sorting for Unicode characters. |
Cyrillic_General_CI_AS | Cyrillic_General (Cyrillic character set), case-insensitive, accent-sensitive. |
Latin1_General_100_CI_AS_SC_UTF8 | Latin1_General (Latin character set), case-insensitive, accent-sensitive, with support for supplementary Unicode characters and UTF-8 encoding. |
Latin1_General_CI_AS | Latin1_General (Latin character set), case-insensitive and accent-sensitive. |
Latin1_General_CS_AS | Latin1_General (Latin character set), case-sensitive and accent-sensitive. |
SQL_Latin1_General_CP1_CI_AS | For Unicode data, the character set is Latin1_General (Latin character set), which is case-insensitive and accent-sensitive. |
SQL_Latin1_General_CP1_CS_AS | Latin1_General (Latin character set) for Unicode data, case-sensitive, and accent-sensitive. |
Japanese_CI_AS | Japanese, case-insensitive, accent-sensitive. |
Japanese_CS_AS | Japanese, case-sensitive, accent-sensitive. |
Chinese_Taiwan_Stroke_CI_AS | Chinese_Taiwan (Traditional Chinese), case-insensitive, accent-sensitive. |
Chinese_Taiwan_Stroke_CS_AS | Chinese_Taiwan (Traditional Chinese), case-sensitive and accent-sensitive. |
Thai_CI_AS | Thai (Thai), case-insensitive, accent-sensitive. |
Collation options | Description |
Case-sensitive (_CS) | Distinguishes between uppercase and lowercase letters.
tip You can select case-insensitivity by specifying _CI. |
Accent-sensitive (_AS) | Distinguishes between accented and non-accented characters. For example, a and á are different characters. If this option is not specified, the collation is accent-insensitive. RDS for SQL Server treats accented and unaccented forms of letters as identical during sorting. tip You can select accent-insensitivity by specifying _AI. |
Strictly case-sensitive (_BIN) | Binary collation is strictly case-sensitive and accent-sensitive. It treats uppercase and lowercase letters, as well as accented and unaccented characters, as different characters. For example, A and a are treated as different characters, and a and á are also treated as different characters. |
Instance character set suffix | Description |
_CI_AS | Case-insensitive and accent-sensitive. |
_CS_AS | Case-sensitive and accent-sensitive. |
_CI_AI | Case-insensitive, accent-insensitive. |
_SC_UTF8 | Supports Unicode supplementary characters and UTF-8 encoding. |
Windows regional settings | Default collation |
Afrikaans (South Africa) | Latin1_General_CI_AS |
Alsatian (France) | Latin1_General_CI_AS |
Basque (Basque) | Latin1_General_CI_AS |
Bosnian (Bosnia and Herzegovina, Latin) | Latin1_General_CI_AS |
Bulgarian (Bulgaria) | Cyrillic_General_CI_AS |
Chinese (Macao SAR) | Latin1_General_CI_AI |
Chinese (People's Republic of China) | Chinese_PRC_CI_AS |
Dutch (Netherlands) | Latin1_General_CI_AS |
English (Australia) | Latin1_General_CI_AS |
English (India) | Latin1_General_CI_AS |
English (Canada) | Latin1_General_CI_AS |
English (New Zealand) | Latin1_General_CI_AS |
English (UK) | Latin1_General_CI_AS |
English (United States) | Latin1_General_CI_AS |
Filipino (Philippines) | Latin1_General_CI_AS |
Italian | Latin1_General_CI_AS |
Thai (Thailand) | Thai_CI_AS |