ApsaraDB RDS:Use the self-service diagnostics feature

Implementation

• The self-service diagnostics feature can test the connectivity between the connection initiator and your RDS instance. For example, if the IP address of the connection initiator is not added to the IP address whitelist of your RDS instance, the connectivity test fails.

• The self-service diagnostics feature can test whether the IP address of the connection initiator is within a CIDR block that is added to the IP address of your RDS instance. If the IP address of the connection initiator is within the CIDR block, the connectivity test succeeds.

Usage notes

If your RDS instance is deployed in a virtual private cloud (VPC), the Elastic Compute Service (ECS) instance that resides in the same VPC can connect to your RDS instance over an internal network. If the ECS instance and the RDS instance reside in different VPCs, the ECS instance cannot connect to the RDS instance even if the IP address of the ECS instance is added to the IP address whitelist of the RDS instance.

Procedure

1. Log on to the ApsaraDB RDS console and go to the Instances page. In the top navigation bar, select the region in which your RDS instance resides. Then, find the RDS instance and click the ID of the RDS instance.

2. In the left-side navigation pane, click Database Connection.

3. In the Connection Troubleshooting section, add the private IP address of an Elastic Compute Service (ECS) instance or public IP address of an on-premises device that can be used to connect to your RDS instance.

   • To add an internal endpoint, click the Intranet Troubleshooting tab and click Add intranet ECS IP. In the dialog box that appears, select the ECS instance that you want to add, add it to the Selected ECS instances section, and then click OK.

   • To add a public endpoint, click the Extranet Troubleshooting tab and click Add Extranet IP. In the dialog box that appears, enter the IP address or click Load Local Public IP Address (If there is a network proxy on your PC, please turn it off first). Then, click OK.

     Note

     You can obtain the public IP address of your local computer in one-click mode only when the network proxy is disabled.

4. Click Start Check.

   Perform subsequent operations based on different test statuses.

   Status	Operation
   Normal	In this case, no action is required.
   IP is not in the instance whitelist.	Click Configure Whitelist in the Action column to add the IP address to the whitelist. For more information, see Configure an IP address whitelist.
   Abnormal	Click Submit Ticket in the Action column to submit a ticket.

References

• You can add the private IP address of your ECS instance or the public IP address of your on-premises device to an IP address whitelist of the RDS instance. For more information, see Configure an IP address whitelist.

• If you want to connect to the RDS instance over the Internet, you can apply for a public endpoint. For more information, see Apply for or release a public endpoint.

• After the connection issues are resolved, you can connect to an RDS instance by using the SQL Server Management Studio (SSMS) client or Data Management (DMS) that is provided by Alibaba Cloud. For more information, see Connect to an ApsaraDB RDS for SQL Server instance.