I have a question related to the lost sa password. I lost my sa password as well and tried to apply your solution. Somehow the password does not end up in the errorlog file, or I must have missed it. Could you help me with this? I have another account in my database but none seem to have sufficient privileges to change the sa password, or change its own properties to become sa equivalent.
The following information might be useful for helping me:
[root@Buzz auditinit]# more version Auditinit/12.5.2/EBF 11799/P/Linux Intel/Enterprise Linux/2186/32-bit/OPT/Fri Mar 26 21:30:17 2004 [root@Buzz auditinit]# uname -a Linux Buzz 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown
/apps/sybase/sqlserver/1252/ASE-12_5/bin/dataserver -slon_gen_sql_tst1 -d/data1/lon_gen_sql_tst1/master.dat -e/apps/sybase/sqlserver/1252/ASE-12_5/install/lon_gen_sql_tst1.log -M/apps/sybase/sqlserver/1252/ASE-12_5 -c/apps/sybase/sqlserver/1252/ASE-12_5/lon_gen_sql_tst1.cfg -i/apps/sybase/sqlserver/1252 -psaOnce you have started Sybase with startserver -f command, a line will appear as below:
New SSO password for sa:bpzinnxhdgyam9This is not written to the errorlog BUT will be displayed on the screen. Make sure that you spot it.
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.