You can connect to an RDS instance through a SQL Server client. This article introduces the connection procedure by taking the Microsoft SQL Server Management Studio (SSMS) client as an example.
Since RDS for SQL Server is fully compatible with SQL Server, the same method may be used to connect to the database. This article takes the SSMS client as an example to connect to an RDS instance. You can refer to this method when using other clients. When you connect to an RDS instance through clients, pay attention to 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 white list. For more information on how to set white list, see Set the white list.
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 should be separated by a comma, for example,
rm-bptest.sqlserver.rds.aliyuncs.com,3433. The following shows the procedure 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.