This topic describes how to reset the password of an account on an ApsaraDB RDS for SQL Server instance. If the password of an account is lost, you can reset the password in the ApsaraDB RDS console.
Limits
If Enforce password expiration and Enforce password policy are configured for your RDS instance, you cannot change the password in the ApsaraDB RDS console. In this case, you can execute the following SQL statements to change the password after you connect to the RDS instance.
USE Master
GO
ALTER LOGIN UserName WITH PASSWORD = 'password'
GO
ALTER LOGIN UserName WITH
CHECK_POLICY = OFF,
CHECK_EXPIRATION = OFF;Procedure
For data security purposes, we recommend that you change passwords on a regular basis.
- Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the left-side navigation pane, click Accounts.
On the tab that appears, find the account for which you want to reset the password and click Reset Password in the Actions column.
In the dialog box that appears, enter a new password in the New Password and Confirm New Password fields and click OK.
The password must meet the following requirements:
The password is 8 to 32 characters in length.
The password contains at least three types of the following characters: uppercase letters, lowercase letters, digits, and special characters.
The password can contain the following special characters: ! @ # $ % ^ & * ( ) _ + - =
Related operations
| Operation | Description |
| ResetAccountPassword | Resets the password of an account on an instance. |