Problem description
When you create an account for an apsaradb for RDS SQL Server instance, the system prompts the "account exceeds the limit" error.
The account exceeds the limit. Databases in an instance share all resources that belong to the instance. You can create up to 500 accounts for each MySQL or SOL Server instance.
There is no limit to the number of accounts for PostgreSQL version instances of MySQL 5.7 and SOL Server2012 version can only create an initial account.
Cause
You cannot create accounts because the number of accounts for an apsaradb for RDS SQL Server instance has exceeded the upper limit.
Solution
The solution varies according to the RDS RDS SQL Server instance version. The details are as follows:
Note: for more information about how to query the RDS instance version, see RDS instance details.
- 2017 cluster version: if you encounter this error, we recommend that you first try to create a database user using SQL commands, for more information, see create database users.
- 2008R2: you can create accounts in the console. However, if the maximum number of accounts exceeds 500, you cannot create more accounts. For more information, see more information.
- Other versions: there is no limit on the number of accounts. If this error occurs, we recommend that you execute SQL statements to create database users. For more information, see create database users. If the problem persists, take a screenshot and submit a ticket for feedback.
References
How to query the limit on the number of accounts through the interface:
- Run the interface in the OpenAPI Explorer.
- Enter the instance information and click submit request. For more information about how to set these parameters, see instructions in.
- Find the value of AccountMaxQuantity based on the returned data.
Application scope
- ApsaraDB RDS for SQL Server