Changing a Database Port

Scenarios

This section describes how to change the database port of a primary DB instance or a read replica. For primary/standby DB instances, changing the database port of the primary DB instance will cause the database port of the standby DB instance to also be changed accordingly.

Procedure

  1. Log in to the management console.

  2. Click image1 in the upper left corner and select a region and a project.

  3. Click Service List. Under Database, click Relational Database Service. The RDS console is displayed.

  4. On the Instances page, click the target DB instance or click image2 first and then click the target read replica.

  5. In the Connection Information area on the Basic Information page, click image3 in the Database Port field.

    Note

    The DB instance port is 1433 by default or it can be set to a value from 2100 to 9500, excluding 5355 and 5985.

    • To submit the change, click image4.

      • In the dialog box, click Yes.

        1. If you change the database port of the primary DB instance, that of the standby DB instance will also be changed and both DB instances will be rebooted.

        2. If you change the database port of a read replica, the change will not affect other DB instances. Only the read replica will reboot.

          Note

          RDS for SQL Server 2019 Enterprise Edition and 2017 Enterprise Edition support read replicas.

        3. This process takes 1-5 minutes.

      • In the dialog box, click No to cancel the modification.

    • To cancel the change, click image5.

  6. View the results on the Basic Information page.