ApsaraDB RDS:Log on to a temporary instance

Method 1: DMS

Data Management (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. to help enterprises efficiently and securely extract data value and accelerate 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 navigate to the DMS logon page.

   

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

   • For Access Mode, select Account and Password Logon as an example.

   • Enter the Database Account and Database Password. For this tutorial, use the privileged account testuser and a user-defined password.

   • Select a Control Mode. In this example, select Flexible Management.

     Note

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

     • Compared to the control mode of Flexible Management, Stable Change and Security Collaboration offer more features and enhanced database control. If you are evaluating ApsaraDB RDS for SQL Server, we recommend using the Flexible Management mode.

4. After a successful logon, you can view the newly created database in the Logged-in Instances list on the left side 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 DMS logged-in instance list, it may be for one of the following reasons:

   • The logon account does not have permission to access the target database: Go to the Accounts page on the RDS instance details page and click Actions in the Change Permissions column for the target account to grant permissions.

   • The directory cannot be displayed because metadata is not synchronized: Hover the pointer over the instance to which the target database belongs. Click the button to the right of the instance name to refresh the database list and display the target database.

5. After you successfully log on to the SQL Server database in DMS, you can create databases, create tables, and query and change table data in the SQL Console.

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.