I have lost the 'sa' password to my database, and I don't know how to retrieve it. Is this a situation where I
will have to just reset the 'sa' password? I do not have any other account into the database.
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.
Dig deeper on Open source databases
Related Q&A from Mich Talebzadeh
Sybase expert Mich Talebzadeh explains how to log on in ASE.continue reading
Sybase expert Mich Talebzadeh gives fifteen reasons for why Sybase will definitely be around for years to come.continue reading
Sybase expert Mich Talebzadeh explains the syntax for user-defined Sybase functions.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.