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. The built-in Database Backup Service (DBS) also provides low-cost and highly reliable backup and recovery capabilities. DMS is designed to help enterprises efficiently and securely unlock the value of their data 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 open the DMS logon page.

   

3. In the Log on to Database Instance dialog box, enter your credentials 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 as an example.

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

     Note

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

     • Unlike the Flexible Management Control Mode, the Stable Change and Security Collaboration modes offer more features and greater control over the database. If you are trying out an RDS for SQL Server instance, we recommend that you select the Flexible Management mode.

4. View the database. After you log on, you can find the new database in the Instances Connected section in the left-side navigation pane of the DMS console. This tutorial uses the dbtest database as an example. You can also double-click other databases to switch between them.

   

   Note

   If the instance exists but the target database is not displayed in the list of connected instances in DMS, the possible causes are:

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

   • The database tree is not displayed because the metadata is out of sync: Move the pointer over the instance to which the target database belongs and click the icon next to the instance name to refresh the database list and display the target database.

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

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.