ApsaraDB RDS:Log on to a temporary instance

Method 1: DMS

Data Management Service (DMS) is a one-stop data management platform that supports the entire data lifecycle. It provides features such as global data asset management, data governance, database design and development, data integration, data development, and data consumption. DMS helps enterprises efficiently and securely unlock the value of their data and accelerates their digital transformation.

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. Click Log On to Database to open the DMS logon page.

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

   • Select an Access Mode. This tutorial uses Account + password login as an example.

   • Enter the Database Account and Database Password. This tutorial uses the privileged account testuser and a custom password.

   • Select a Control Mode. This tutorial uses Flexible Management as an example.

     Note

     • Flexible Management is free of charge. Stable Change and Security Collaboration incur fees.

     • Compared to the Flexible Management control mode, Stable Change and Security Collaboration offer more advanced database management features. If you are trying out ApsaraDB for SQL Server, we recommend selecting the Flexible Management mode.

4. After you log on, the newly created database appears under Instances Connected in the left navigation pane of the DMS page. This tutorial uses the dbtest database as an example. You can also double-click another database to switch to it.

   Note

   If the instance exists but the target database is not found in the list of connected instances in DMS, the cause may be one of the following:

   • The logon account does not have permissions to access the target database: Go to the Accounts page of the ApsaraDB RDS instance, find the target account, and click Change Permissions in the Actions column to grant the required permissions.

   • The directory is not displayed because the metadata is not synchronized: Hover the pointer over the instance that contains the target database and click the icon to the right of the instance name. This refreshes the list to display the target database.

5. After logging on to the database in DMS, use the SQL Console tab to create databases and tables, and to query and modify data.

Method 2: SSMS on an ECS instance

1. Prepare an ECS instance (Windows Server) to access the temporary RDS instance.

   Note

   The ECS instance and the temporary RDS instance must be in the same region and the same VPC.

2. Add the internal IP address of the ECS instance to the whitelist of the temporary RDS instance.

3. Log on to the ECS instance. Then, install and open SQL Server Management Studio (SSMS) on the instance.

   Note

   We recommend that you download the latest version of the client to ensure compatibility with all versions of SQL Server.

4. In the Connect to Server dialog box, enter the logon information.

   Parameter	Value	Description
   Server Name	rm-2ze****.rds.aliyuncs.com,1433	The RDS instance's internal endpoint and port, separated by a comma (,).
   Authentication	SQL Server Authentication	The authentication method for SQL Server.
   Login	testuser	The username of the database account.
   Password	Test_pw123	The password for the database account.

5. Click Connect to connect to the instance.

   Once connected, the database's connection information appears in the left-side pane of SSMS.