All Products
Search

This Product

    ApsaraDB RDS:Use DMS to log on to an ApsaraDB RDS for SQL Server instance

    Document Center

    ApsaraDB RDS:Use DMS to log on to an ApsaraDB RDS for SQL Server instance

    Last Updated:Oct 29, 2024

    This topic describes how to log on to an ApsaraDB RDS for SQL Server instance by using Alibaba Cloud Data Management (DMS). This way, you do not need to configure the IP address whitelist and the connection type of the instance when you log on to the instance.

    Background information

    DMS is a one-stop data management platform that supports various features across the full data lifecycle, including all-domain data asset management, data governance, database design and development, data integration, data development, and data consumption. Dedicated to helping enterprises in efficient and secure data exploration, DMS can play an important role in accelerating the digitalization of the enterprises. For more information about DMS, see What is DMS?

    Procedure

    1. Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.

    2. On the page that appears, click Log On to Database.

      image..png

    3. In the Log on to Database Instance dialog box, enter the logon information and click Login.

      image

      • Configure the Access Mode parameter. In this topic, Account + password login is selected.

      • Configure the Database Account and Database Password parameters. In this topic, a privileged account named testuser and a custom password are used.

      • Configure the Control Mode parameter. In this topic, Flexible Management is selected.

        Note

        • If your RDS instance is managed in Flexible Management mode, you can use DMS to manage the instance free of charge. If your RDS instance is managed in Stable Change or Security Collaboration, fees are generated. For more information, see Pricing.

        • Compared with the Flexible Management mode, the Stable Change and Security Collaboration modes provide more features and enhanced database management capabilities. If your RDS instance is for trial use, we recommend that you select Flexible Management. For more information, see Control modes.

    4. View the database. In the left-side navigation pane of the DMS console, choose Database Instances > Instances Connected to view the database that you create. In this topic, the database named dbtest is displayed. You can also double-click a database.

      image

      Note

      If the RDS instance exists but the required database is not displayed on the Instance Connected page of the DMS console, troubleshoot the issue based on the following information:

      • The logon account does not have the permissions to connect to the required database. In this case, you can go to the Accounts page of the RDS instance, find the logon account, and then click Change Permissions in the Actions column to grant the required permissions. For more information, see Modify the permissions of an account.

      • The metadata of the required database is not synchronized. In this case, move the pointer over the RDS instance to which the required database belongs and click the image icon to the right of the instance name. Then, you can find the required database.

    Reference

    You can also use a client to remotely connect to an ApsaraDB RDS for SQL Server database. For more information, see Connect to an ApsaraDB RDS for SQL Server instance.