sa password change

[nyck]

Hello,

one of our users has managed to change the sa password and we are now unable to login as the sa user. can anyone suggest what i can do here?

cheers

nick

 

[tahirkhalil]

If you dont have anyother options left like someone with sa_role or sso_role - there is only one option left - restart the adaptive server.

Normaly you can get new SA password by adding an additional parameter in your startserver runfile. Following is the example of a Unix based server RUN_file.

/opt/sybase-11.9.2/bin/dataserver \
-sN_UTSIRE \
-d/data/sybase/databases/N_UTSIRE/master.dat \
-e/opt/sybase-11.9.2/install/N_UTSIRE.log \
-M/opt/sybase-11.9.2 -psa \

the additional -psa will show you the password while you start the server again - you can see like :

00:00000:00001:2001/05/26 18:29:21.39 server 'bin_iso_1' (ID = 50)
00:00000:00001:2001/05/26 18:29:21.39 server on top of default character set:
00:00000:00001:2001/05/26 18:29:21.39 server 'iso_1' (ID = 1).
00:00000:00001:2001/05/26 18:29:21.39 server Loaded default Unilib conversion handle.

New SSO password for sa:tmfyrkdwpibung