Retrieve the lost SA password in Sybase

Retrieve the lost SA password in Sybase
1. Start the Server File In the install subdirectory of the Sybase directory.
Run_server (here the server represents your server name, for example, here I am run_fenglb) Name, edit this file,
Add the parameter-PSA after "<Sybase directory>/data/master. dat-sfenglb,
Save the file.

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

3. Start a DOS window, go to the install directory above, set the screen buffer size of the DOS window attribute to 9999, and execute Step 1 batch file to start the server, after the startup, copy all the content in the DOS window to the notebook and search for the string "New SSO password for SA:", followed by the new SA password.


4. Switch to SQL advangtage and log on with the SA account. The password is the obtained password.

5. After Entering the server, run sp_password to modify the SA password: sp_password 'old password', 'new password', and 'username'
The number of digits of the new password must be greater than 6. Otherwise, the password cannot be changed.

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

This article is from:Feng Libin's blog