SAP ASE forget password reset

Reset sa & sapsa Password of SAP Sybase ASE in LINUX Version 15.1.134

1 Symptoms Reset password of SAP Sybase ASE “sa & sapsa” user in Linux after forgot.

2 Prerequisites

a. Login access of sybsid & sidadm user.

b. Should have proper compress Database dump

c. Instance should be complete stop with stopsap

3 Solutions

(a) Stop sap and database instance with command “stopsap" with user sidadm in terminal.

(b) Go to location “/Sybase/SID/ASE-15_0/install”

(c) Open RUN_SID file and Add text –psa in to last line of RUN_SID file with sybsid user and save

(d) Now execute command for start only database server manually startserver –f RUN_SID.

(e) While executing you will get random password of “sa” users as per below screen shot.

(f) After generate random password of sa user remove –psa entry from RUN_SID file

(g) start sap instance server startsap

(h) Copy generated sa password and Login into isql database with help of sa user.

“isql –Usa –Pyavqkdpmybvwr3 –SSID –X”

(i) After successfully logon in to sa user, change the password of sapsa user.

Password has been successfully changed.

#sapsybase #sapsybasepasswordreset #sapASEforgetpassword #SAPASEforgetpasswordreset #howtoSAPASEforgetpasswordreset