You can connect to an RDS instance through the SQL Server client. This document introduces the connection procedure by taking the Microsoft SQL Server Management Studio (SSMS) client as an example.
Because RDS for SQL Server is fully compatible with SQL Server, the same method may be used to connect to the database. Here, we take the SSMS client as an example to connect to an RDS instance. You can see this method when using other clients. When you connect to an RDS instance through clients, consider the following information on the selection of the connection address.
Use the intranet address when your client is installed on the ECS that is located in the same region and the same network type with those of the RDS instance to be connected.
Use the Internet address for the other situations.
Add the IP address accessing the RDS instance to RDS whitelist. For more information, see Set the whitelist.
Start the Microsoft SQL Server Management Studio client.
Enter the connection information, as shown in the following figure.
Server type: select Database Engine.
Server name: consists of the Internet/intranet address and the corresponding port number of the RDS instance. The connection address and the port number must be separated by a comma, for example,
rm-bptest.sqlserver.rds.aliyuncs.com,3433. Do the following steps to view the connection address and the port information of the RDS instance.
Log on to the
Select the region where the target instance is located.
Click the ID of the instance to visit the Basic Information page.
In the Basic Information area, you can find the Internet/intranet address and Internet/intranet port number of the instance, as shown in the following figure.
Authentication: select SQL Server Authentication.
Login: refers to the initial account name of the RDS instance.
Password: refers to the password corresponding to the initial account of the RDS instance.