This topic describes how to connect to an ApsaraDB RDS for SQL Server instance. After
you complete the initial configuration, you can connect to your RDS instance from
an Elastic Compute Service (ECS) instance or your computer.
Use DMS to connect to your RDS instance
Data Management (DMS) is a graphical data management service that allows you to manage
relational databases and NoSQL databases. It provides various functions, such as data
management, schema management, user authorization, security audit, trend analysis,
data tracking, business intelligence (BI) charts, and performance analysis and optimization.
For more information about how to connect to your RDS instance by using DMS, see Use DMS to log on to an ApsaraDB RDS for SQL Server instance.
Use a database client to connect to your RDS instance
In this section, the Microsoft SQL Server Management Studio (SSMS) client is used
as an example. For more information, visit
Microsoft SQL Server Management Studio.
Note We recommend that you install the latest version of database client. This allows you
to use all the supported versions of SQL Server in your database system.
- Start the SSMS client on your ECS instance or computer.
- Choose .
- In the Connect to Server dialog box, enter the information that is used to log on to your RDS instance.

Parameter |
Description |
Server type |
Select Database Engine.
|
Server name |
Enter the endpoint and port number of your RDS instance. The endpoint and the port
number are separated by a comma (,). Example: rm-bptest.sqlserver.rds.aliyuncs.com,3433 .
For more information about how to view the internal and public endpoints and port
numbers of your RDS instance, see View and change the internal and public endpoints and port numbers of an ApsaraDB RDS for SQL Server instance.
|
Authentication |
Select SQL Server Authentication.
|
Login |
Enter the username of the account that is authorized to log on to your RDS instance. |
Password |
Enter the password of the account that is authorized to log on to your RDS instance. |
- Click Connect.
FAQ
How do I obtain data from ApsaraDB RDS to Function Compute?
You can install third-party dependencies on Function Compute. Then, you can use these
built-in dependencies to obtain data from ApsaraDB RDS.For more information, see Install third-party dependencies.