Setting the Maximum Number of Connections for a Database Account

Scenarios

RDS for SQL Server allows you to set the maximum number of connections to an instance through a specific database account. This setting is used to limit the number of new connections accessing the instance.

Constraints

• To use this function, submit a service ticket to request required permissions.
• After you set the maximum number of connections, the system does not clean up the sessions that are already connected. It only checks the number of new connections.

Procedure

1. Click in the upper left corner and select a region.
2. Click in the upper left corner of the page and choose Databases > Relational Database Service.
3. On the Instances page, click the target instance name to go to the Overview page.
4. In the navigation pane on the left, choose Databases and Accounts and then click the Accounts tab.
5. Locate the target account and click Set Max. Connections in the Operation column.
6. In the displayed dialog box, set required parameters and click OK.
   Figure 1 Setting the maximum number of connections
   

   Enter a value from 0 to 32767.

   If you set the maximum number of connections to 0, the account cannot create any new connections. To allow unlimited connections, set this parameter to the maximum value.