Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document.
Note: Even the most advanced machine translation cannot match the quality of professional translators.
Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
How Do I Change the Password of the Administrator of the SQL Server Database
Question
How do I change the password of the administrator of the SQL Server database?
When eSight is installed, use the maintenance tool to change the database password. Otherwise, some problems may occur on eSight.
Answer
- Run the cmd.exe command to start the CLI of the Windows operating system and run the following script.
- The administrator password can only contain uppercase letters, lowercase letters, digits, and the following special characters: ~@#^*()-_+|[{}]:./?
- The administrator password contains 8 to 32 characters.
osql -Uuser -Ppassword sp_password null, 'New password' go exit
- user: The sa user or a user with the same permission as the sa user.
- password: The database login password.
- When the password is changed, run the following command to log in to the SQL Server database:
If the login succeeds, the password is changed successfully.
osql -Uuser -PNew password
