edit-icon download-icon

Create database and account for SQL Server 2008 R2

Last Updated: Jan 10, 2018

Note: This document is applicable only to SQL Server 2008 R2. For more information on how to create a database and an account for SQL Server 2012, see Create a database and an account for SQL Server 2012.

Before using RDS, you must create databases and accounts in the RDS instance. For SQL Server 2008 R2, this document describes the procedure to create and manage the databases and accounts directly by using the RDS console.

Attention

  • Databases under a single instance share all the resources of this instance. Each SQL Server 2008 R2 instance supports up to 50 databases and 500 accounts.

  • To migrate the local database to RDS, you must create the same database and account as those of the local database.

  • When assigning account permissions for each database, follow the minimum permissions principle and service roles to create accounts and rationally assign Read-only and Read/Write permissions. When necessary, you can split accounts and databases into smaller units so that each account can only access data of its own services. If the account does not need to write data to a database, assign Read-only permission.

  • For database security, set strong passwords for the accounts and change the passwords regularly.

Procedure

  1. Log on to the RDS console.

  2. Select the region where the target instance is located.

  3. Click the ID of the instance to visit the Basic Information page.

  4. Select Account Management in the left-side navigation pane to visit the Account Management page.

  5. Click Create Account.

    Create account button

  6. To create an account, enter the relevant details in the required fields.

    Set account information

    Parameters description:

    • Database Account: refers to the account name. It can have 2 to 16 characters including lower-case letters, digits, or underscores (_). It must begin with a letter and end with a letter or a digit.

    • Authorized Database: refers to the database that this account is authorized to access. If there is no database, you do not need set this field. Follow the steps to authorize an account to the multiple databases:

      1. In Unauthorized Database box, select the target database.

      2. Click Authorize to add the selected database to the Authorized Database box.

      3. You can authorize the Read-only or Read/Write permission to the account for each authorized database. If you want to authorize the same permissions to the account for all the authorized databases, click Set All Read/Write or Set All Read-only.

        Authorize the account

    • Password: refers to the password corresponding to this account. It can have 8 to 32 characters including at least three of the following:

      • Capital letters

      • Lower-case letters

      • Digits

      • Special characters ( !@#$%^&*()_-+=)

    • Re-enter Password: re-enter the password to make sure the password is entered correctly.

    • Note: you can add the additional information relevant to this account for the convenience of follow-up account management. A maximum of 256 characters can be entered.

  7. Click OK to complete the account creation process.

  8. Select Database Management in the left-side navigation pane to visit the Database Management page.

  9. Click Create Database.

    Create database button

  10. Enter the information of the database.

    Set database information

    Parameters description:

    • Database (DB) Name: can have 2 to 64 characters including the lowercase letters, digits, underscores (_), or hyphens (-). It must begin with a letter and end with a letter or a digit.

    • Supported Character Set: refers to the supported character set of the database. Select the suitable character set as per your need.

    • Authorized Account: you can select an account authorized to access this database. Set this field only if the account is created.

    • Account Type: this option is visible after Authorized Account is set. You can authorize Read/Write or Read-only permission to the authorized account.

    • Remarks: enter the additional information relevant to this database, to facilitate the database management for further follow-up. A maximum of 256 characters can be entered.

Thank you! We've received your feedback.