how can i restore a lost sa password in SYBASE? There is no other account I
can use to change the password with. Please help!!!!

Leonard

On Tue, 27 Sep 2005 22:58:43 -0400, Leonard Gary wrote:

> how can i restore a lost sa password in SYBASE? There is no other account
> I can use to change the password with. Please help!!!!

Edit the RUN_xxx file and add the -psa option. Restart the server. A
new sa password will be printed to the console.

Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html

.... and remember to then remove the -psa from the RUN_xxx file or the
password will be changed on you every time ASE is rebooted, which
probably isn't what you want.

Note that the password is being printed earlier in the boot sequence
now than it was in earlier versions of ASE. (this is a side effect of
the parallel user database recovery feature)

-bret