This topic describes how to connect to an ApsaraDB RDS for SQL Server instance. After you complete the initial configuration for an RDS instance, you can connect to the RDS instance from your Elastic Compute Service (ECS) instance or your computer.
Use DMS to connect to an RDS instance
Data Management (DMS) is a graphical data management service that provides various features for you to manage relational databases and NoSQL databases. These features include data management, schema management, user authorization, security audit, trend analysis, data tracking, business intelligence (BI) charting, and performance analysis and optimization.
For more information, see Use DMS to log on to an ApsaraDB RDS for SQL Server instance.
Use a database client to connect to an RDS instance
- Start the SSMS client on your ECS instance or your computer.
- Choose .
- In the Connect to Server dialog box, enter the information that is used to log on to the RDS instance.
Parameter Description Server type Select Database Engine. Server name Enter the endpoint and port number that are used to connect to the RDS instance. The endpoint and the port number are separated by a comma (,). Example:
For more information about how to view the internal and public endpoints and port numbers of an 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 the RDS instance. Password Enter the password of the preceding account.
- Click Connect.
How do I use Function Compute to obtain data from my RDS instance?
You can install third-party dependencies on Function Compute. Then, you can obtain data from your RDS instance by using the built-in modules that are provided by the third-party dependencies in Function Compute. For more information, see Install third-party dependencies on Function Compute.