If you have lost the 'sa' password, then you can regenerate another one. To do so follow the following example
- Shutdown the Sybase server from the operating system level by using a kill command. I assume that since you have lost the 'sa' password then you have not used the server for a while!
- Once you have shutdown the ASE, modify the RUN_SERVER file as follows:
/sybase/ase/sqlserver/1251/ASE-12_5/bin/dataserver -sSYB_CRFXR1_1251 -d/sybase/ase/SYB_CRFXR1_1251/data/master.dat -e/sybase/ase/sqlserver/1251/ASE-12_5/install/SYB_CRFXR1_1251.log -c/sybase/ase/sqlserver/1251/ASE-12_5/SYB_CRFXR1_1251.cfg -M/sybase/ase/sqlserver/1251/ASE-12_5 -psaNotice the last line "-psa". This will instruct Sybase to create a login for 'sa'. The password will be written to the ASE's errorlog. In this example our server is called SYB_CRFXR1_1251 and the errorlog will be SYB_CRFXR1_1251.log, by default.
Use the regenerated 'sa' password to access your ASE as usual, once you have rebooted your ASE. Reset the 'sa' password using exec sp_password afterwards and do not forget to remove the last line in the RUN_SERVER file.
For More Information
- Dozens more answers to tough Sybase questions from Mich Talebzadeh are available here.
- The Best Sybase Web Links: tips, tutorials, scripts, and more.
- Ask the Experts yourself: Our SQL, database design, SQL Server, DB2, Sybase, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in June 2004