Reset an account password when you forget it or when a password expires and causes login failures. You can reset passwords from the ApsaraDB RDS console or by calling an API operation.
Change account passwords regularly, especially when multiple users share access, when permissions change, or during security audits. To enforce password rotation automatically, configure a password policy.
Prerequisites
Before you begin, ensure that you have:
-
An ApsaraDB RDS for SQL Server instance
-
Access to the ApsaraDB RDS console
Limitations
If both Enforce password expiration and Enforce password policy are enabled on the instance, you cannot reset the password from the console. Instead, connect to the instance and run the following SQL statements:
Reset an account password
-
Go to the Instances page. In the top navigation bar, select the region where your instance resides. Find the instance and click its ID.
-
In the left-side navigation pane, click Accounts.
-
Find the account whose password you want to reset and click Reset Password in the Actions column.
-
In the dialog box, enter a new password in the New Password and Confirm New Password fields, then click OK. The password must meet the following requirements:
Requirement Detail Length 8 to 32 characters Character types At least three of the following: uppercase letters, lowercase letters, digits, and special characters Allowed special characters ! @ # $ % ^ & * ( ) _ + - =