Create Database

1. Log in to the console ->ApsaraDB ->Manage ApsaraDB instances.

2. Find the target instance where the database needs to be created, and click Manage

3. Click Database Management

4. On the database management page, click Create Database

5. Enter the database name, select the appropriate character set, and click OK

Character sets supported by SQL Server:

• Chinese_PRC_CI_AS
• Chinese_PRC_CS_AS
• SQL_Latin1_General_CP1_CI_AS
• SQL_Latin1_General_CP1_CS_AS
• Chinese_PRC_BIN

Suffix Description

 _CI: Do not partition case_ CS: case sensitive_ BIN: Sort by binary, case sensitive.

Create account

matters needing attention:

• When assigning database account permissions, please create accounts according to the principle of minimum permissions and business roles, and reasonably allocate read-only and read-write permissions. If necessary, the database account and database can be split into smaller granularity, so that each database account can only access data within its business. If no database write operation is required, assign read-only permission.
• To ensure the security of the database, please set the password of the database account to a strong password and change it regularly.

one Click Account Management

2. Click Create Account

3. Enter the database account information and click OK.

Parameter description:

Create a high authority account as shown in the following figure:

Create a common account as shown in the following figure:

After the account is created, you need to grant the account permission to connect to the database.

Initialization settings are complete. Refer to Connect to SQLServer Database InstanceConnect to SQLServer Instance.