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

In this section, the Microsoft SQL Server Management Studio (SSMS) client is used as an example. For more information, visit the Microsoft SQL Server Management Studio page.
Note We recommend that you download the latest version of SSMS to support all SQL Server versions.
  1. Start the SSMS client on your ECS instance or your computer.
  2. Choose Connect > Database Engine.
  3. 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: rm-bptest.sqlserver.rds.aliyuncs.com,3433.

    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.
  4. Click Connect.

FAQ

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.