This topic describes the common errors and provides answers to some commonly asked questions about the IP address whitelist settings of an ApsaraDB RDS for SQL Server instance.

Common errors

ErrorDescriptionSolution
No IP address whitelists are configured. Your RDS instance has only one default IP address whitelist. The default IP address whitelist contains only the 127.0.0.1 IP address.The 127.0.0.1 IP address indicates that no devices can access your RDS instance.Add the IP addresses of the specified devices to an IP address whitelist.
The 0.0.0.0 entry is added to an IP address whitelist during a connectivity test.The format of the 0.0.0.0 entry is invalid.Change the 0.0.0.0 IP address to the 0.0.0.0/0 Classless Inter-Domain Routing (CIDR) block.
Important The 0.0.0.0/0 CIDR block indicates that all IP addresses are granted access to your RDS instance. We recommend that you add this CIDR block only for a connectivity test. When you run online workloads, do not add this CIDR block to an IP address whitelist.
The public IP addresses in a configured IP address whitelist are inaccessible.
  • The public IP addresses dynamically change.
  • The tool or website that you use to query public IP addresses returns inaccurate results.
For more information, see How do I locate the IP address connected to an RDS for SQL Server instance?.

FAQ

  • After I configure an IP address whitelist for my RDS instance, does the IP address whitelist immediately take effect?

    After you configure an IP address whitelist for your RDS instance, the IP address whitelist requires about 1 minute to take effect.

  • What are the IP address whitelists labeled ali_dms_group and hdm_security_ips?

    When you connect to your RDS instance from Data Management (DMS) and Database Autonomy Service (DAS), the system generates IP address whitelists for DMS and DAS upon your authorization. The IP address whitelist labeled ali_dms_group is generated for DMS. The IP address whitelist labeled hdm_security_ips is generated for DAS. Do not modify or delete the IP address whitelists. If you modify or delete the IP address whitelists, these services cannot access your RDS instance. These services do not perform operations on your business data.

    Important If an RDS instance is created after December 2020, the IP address whitelist that is labeled hdm_security_ips is invisible to users. This prevents the IP address whitelist from being unintentionally modified or deleted.
    hdm_security_ips
  • If I disable Internet access and enable only internal network access, is my RDS instance exposed to security risks? We recommend that you migrate your RDS instance to a virtual private cloud (VPC). For more information, see Change the network type of an ApsaraDB RDS for SQL Server instance.