Lost the 'sa' password
I have lost the 'sa' password to my database, and I don't know how to retrieve it. Is this a situation where I...
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
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 -psa
Notice 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 Linux servers
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Center experts
View all Data Center questions and answers
Start the conversation
0 comments