This topic describes how to log on to an ApsaraDB RDS for SQL Server instance by using Alibaba Cloud Data Management (DMS).

Background information

DMS offers an integrated solution for data, schema, and server management, user authorization, security audit, trend analysis, data tracking, business intelligence (BI) charts, and performance analysis and optimization.

Log on to your RDS instance by using the new DMS console

Prerequisites

You have an Alibaba Cloud account. Otherwise, you have the credentials of a RAM user who has the permissions on your RDS instance. For more information about how to apply for the permissions, see Permission management.

  1. Log on to the DMS console.
  2. In the left-side navigation pane, select your RDS instance and click Please login first.
    Note If your RDS instance uses the Security Collaboration control mode, you need only to click Logon-free Instances and double-click the instance. You do not need to enter the username and password of the account that is used for the logon.
    Please login first
  3. In the dialog box that appears, enter the username and password of the account used for the logon and click OK.
    Note The account used for the logon must have permissions on the required database. Otherwise, the required database is not displayed in the left-side navigation pane. For more information about how to modify the permissions of an account, see Modify the permissions of a standard account on an ApsaraDB RDS for SQL Server instance.
  4. In the left-side navigation pane, click Instances Connected and double-click your RDS instance to switch to the instance.

Log on to your RDS instance by using the original DMS console

Note If you have upgraded DMS to the new version, we recommend that you use the new DMS console to log on to your RDS instance.
  1. Visit the RDS instance list, select a region above, and click the target instance ID.
  2. In the upper-right corner of the page, click Log On to Database to open the RDS Database Logon page.
    Note Alibaba Cloud directs you to the original or new DMS console based on your logon history.
  3. Configure the following parameters.
    Parameter Description
    Endpoint:Port number The endpoint and port number that are used to log on to your RDS instance. The endpoint and port number are in the <Endpoint>:<Port number> format. Example: rm-bpxxxxxxx.rds.aliyuncs.com:3433. For more information about how to view the endpoint and port number that are used to log on to your RDS instance, see View and change the internal and public endpoints and port numbers of an ApsaraDB RDS for SQL Server instance.
    Database Username The username of the account that is used to log on to your RDS instance.
    Password The password of the preceding account.
  4. Click Log On.
    Note If you want the browser to save the password, select Remember Password before you click Log On.
  5. If you are prompted to add the Classless Inter-Domain Routing (CIDR) block that contains the IP address of the DMS server to an IP address whitelist of your RDS instance, click Specify for All Instances or Specify for Current Instance.
  6. After the CIDR block is added, click Log On.