Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the problem of sa password loss in Sybase database". The content of the explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the problem of sa password loss in Sybase database".

1. Launch the server file in the install subdirectory of the Sybase directory

RUN_server (server here represents your server name, such as mine is RUN_FENGLB) name, edit the file

Add the parameter-psa after "\ data\ master.dat-sFENGLB" to save the file.

2. If the server has been started, stop it first.

3, start a DOS window, go to the install directory above, and set the screen buffer size of the properties of the DOS window to 9999. Step 1 will be performed to batch the file to start server. After starting, all the contents of the DOS window will be copied to the notebook to find the string "New SSO password for sa:". The following is the new password of sa, which needs to be recorded.

4. Switch to SQL Advangtage and log in to your sa account with the password you just got.

5. After entering server, modify the sa password with the command sp_password: sp_password 'original password', 'new password', 'user name'

The number of digits of the new password must be greater than 6 digits, otherwise you cannot change it successfully.

6. Go back to step 1, remove the added option-psa, and save exit.

Thank you for your reading, the above is the content of "how to solve the problem of sa password loss in Sybase database". After the study of this article, I believe you have a deeper understanding of how to solve the problem of sa password loss in Sybase database. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.