What Should I Do If an RDS for SQL Server DB Instance Failed to Be Connected?

Fault Location

• Check whether the RDS DB instance can be pinged from an ECS.

  If no, check whether the ECS and RDS DB instance are located in the same VPC and security group.

  If you intend to connect to a DB instance through a private network, the ECS and RDS DB instance must be in the same VPC and the DB instance can be accessed only through the ECS. If you intend to connect to a DB instance through a public network, they can belong to different VPCs.

• Check whether the IP address and port are correct.

  Use a colon to separate the IP address and port.

• Check whether the RDS service is running properly.
• Check whether the username and password are correct. You can reset the password.
• Reboot the RDS DB instance and check whether it can be connected through an ECS.

Solution

1. Log in to the RDS console.
2. Click in the upper left corner and select a region.
3. On the Instances page, click the target DB instance name. On the Summary and Backups & Restorations pages, check connection and backup information.
4. On the Summary page, check the administrator account.
5. Download a SQL Server Management Studio installation package and install it on an ECS.
6. Connect to the RDS DB instance through the ECS.