1. Start server file in the install subdirectory of the Sybase directory
RUN_server (the server here represents your server name, such as mine is RUN_FENGLB here), edit the file,
Add the parameter -psa after "\data\ -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, set the screen buffer size of the properties of the DOS window to 9999, and perform step 1 batch file to start the server. After startup, copy all the contents in the DOS window into the notebook and 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 with the sa account. The password is the password you just got.
5. After entering the server, use the command sp_password to modify the sa password: sp_password 'original password', 'new password', 'user name'
The number of digits of the new password must be greater than 6 digits, otherwise it cannot be changed successfully.
6. Go back to step 1, remove the added option -psa, save and exit.
RUN_server (the server here represents your server name, such as mine is RUN_FENGLB here), edit the file,
Add the parameter -psa after "\data\ -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, set the screen buffer size of the properties of the DOS window to 9999, and perform step 1 batch file to start the server. After startup, copy all the contents in the DOS window into the notebook and 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 with the sa account. The password is the password you just got.
5. After entering the server, use the command sp_password to modify the sa password: sp_password 'original password', 'new password', 'user name'
The number of digits of the new password must be greater than 6 digits, otherwise it cannot be changed successfully.
6. Go back to step 1, remove the added option -psa, save and exit.