Can't find lost sa password in errorlog file

Can't find lost sa password in errorlog file

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

    Requires Free Membership to View

    Login

    When you register, my team of editors will also send you resources covering Linux administration and management; integration and interoperability between Linux, Windows and Unix; securing Linux and mixed-platform environments; and migrating to Linux.

    Margie Semilof, Editorial Director

    By submitting your registration information to SearchEnterpriseLinux.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchEnterpriseLinux.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

OK, this is actually displayed when you start Sybase. Look at my startup screen. Please note the line "-psa" 
/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 
-psa
Once you have started Sybase with startserver -f command, a line will appear as below: 
New SSO password for sa:bpzinnxhdgyam9
This is not written to the errorlog BUT will be displayed on the screen. Make sure that you spot it.

Good luck.

This was first published in March 2005

Back to top