Updated on 2023-07-06 GMT+08:00

Overview

This section describes how to create a SQL Server DB instance on the management console and bind an EIP to the DB instance to make the instance publicly accessible.

If you are using RDS for the first time, see the constraints described in section Microsoft SQL Server Constraints.

Process

Figure 1 illustrates the process of connecting to a SQL Server DB instance through a public network.

Figure 1 Connecting to a DB instance through a public network
  • Step 2: Bind an EIP. The Elastic IP service provides independent public IP addresses and bandwidth for Internet access. You can apply for an EIP on the VPC console and bind the EIP to the RDS DB instance.
  • Step 3: Configure security group rules. To access an RDS DB instance from resources outside the security group, you need to configure an inbound rule for the security group associated with the RDS DB instance.
  • Step 4: Connect to a DB instance from a public network. You can use SQL Server Management Studio to connect to a DB instance through a common connection or an SSL connection. The SSL connection encrypts data and is more secure.