This topic describes how to create an account and a database for an ApsaraDB RDS instance that runs SQL Server 2008 R2. You can create accounts and databases by using the ApsaraDB RDS console.
Prerequisites
Your RDS instance runs SQL Server 2008 R2.
Note For more information about how to create an account and a database for an RDS instance
that runs a different SQL Server version, see the following topics:
Create an account
Precautions
- Databases on the same RDS instance share all the resources that belong to the RDS instance. You can manage standard accounts and databases by using SQL statements.
- You must follow the principle of least privilege to create accounts and grant the read-only permissions or the read and write permissions to the accounts based on the required roles. If necessary, you can create more than one account and grant each account only the permissions to access the data of specific databases within its authorized workloads. If an account does not need to write data to a database, you must grant only the read-only permissions on the database to the account.
- For security purposes, we recommend that you configure strong passwords for the created accounts and change the passwords on a regular basis.
Procedure
Create a database
References
Migrate data from an on-premises database to ApsaraDB RDS SQL Server 2008 R2 using full backup files
References
- For more information about how to create an account for an RDS instance by calling an API operation, see Create an account.
- For more information about how to create a database for an RDS instance by calling an API operation, see Create database.
- For more information about how to create databases and accounts for an RDS instance
that runs a different database engine, see the following topics:
- Create an account and a database for an ApsaraDB RDS instance that runs SQL Server 2012, 2016, 2017 SE, or 2019 SE
- Create an account and a database for an ApsaraDB RDS instance that runs SQL Server 2008 R2
- Create databases and accounts for an ApsaraDB RDS for PostgreSQL instance
- Create databases and accounts for an ApsaraDB RDS for MariaDB TX instance