This topic describes how to create accounts and databases for an ApsaraDB for RDS instance that runs SQL Server 2012, 2014, 2016, 2017 SE, or 2019. You can create the databases and accounts by using the ApsaraDB for RDS console.

Prerequisites

The RDS instance runs one of the following SQL Server versions:

  • SQL Server 2012
  • SQL Server 2016
  • SQL Server 2017 SE
  • SQL Server 2019
Note For more information about how to create accounts and databases for RDS instances that run other SQL Server versions, see the following topics:

Creates an account

You can create both privileged and standard accounts by using the ApsaraDB for RDS console. However, note that you can create a privileged account only by using the ApsaraDB for RDS console.

Precautions

  • Databases within the same instance share all of the resources that belong to the instance. You can manage standard accounts and databases by using SQL statements.
  • Use service roles to create accounts and follow the principle of least privilege to assign appropriate read-only and read/write permissions to the accounts. When necessary, you can create more than one account and allow each account to access only the data within its authorized workloads. If an account does not need to write data to a database, assign read-only permissions on the database to the account.
  • To ensure database security, configure strong account passwords and change the passwords on a regular basis.

Procedure

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target instance and click the instance ID.

Create a database

  1. Log on to the ApsaraDB for RDS console.
  2. In the left-side navigation pane, click Instances. In the top navigation bar, select the region where the target RDS instance resides.
    Select a region
  3. Find the target instance and click the instance ID.

Related operations

API Description
Create database account Creates an account for an ApsaraDB for RDS instance.
Create database Creates a database for an ApsaraDB for RDS instance.