Skip to Content
0
Former Member
Feb 13, 2015 at 09:20 PM

Reset sa user for ASE 15.7 on Windows 2012 R2

584 Views

Hi Guys

I am new to ASE and i am trying to reset the password for sa user since the customer has none of the DB users passwords, i have tried to reset by note 1872806 - How to set a new password for SA account in Sybase ASE server, here are the steps i have went through:

1- logged in to win by SYBSID user then shutdown the service Sybase SQLServer _ SID

2- Edit file G:\sybase\SID\ASE-15_0\install\RUN_SID.bat to:

rem

rem Adaptive Server Information:

rem name: SID

rem master device: G:\sybase\SID\sybsystem\master.dat

rem server page size: 16384

rem master device size: 400

rem errorlog: G:\sybase\SID\ASE-15_0\install\SBD.log

rem interfaces: G:\sybase\SID\ini

rem

"G:\sybase\SID\ASE-15_0\bin\sqlsrvr.exe" -d"G:\sybase\SID\sybsystem\master.dat" -SID-e"G:\sybase\SID\ASE-15_0\install\SID.log" -i"G:\sybase\SID\ini" -M"G:\sybase\SID\ASE-15_0"

-psa


3- Saved the .bat file


4- in DOS box tried to run RUN_SID as following:

C:\Users\sybSID>G:\sybase\SID\ASE-15_0\install\RUN_SID.bat

C:\Users\sybSID>rem

C:\Users\sybSID>rem Adaptive Server Information:

C:\Users\sybSID>rem name: SID

C:\Users\sybSID>rem master device: G:\sybase\SID\sybsystem\mast

er.dat

C:\Users\sybSID>rem server page size: 16384

C:\Users\sybSID>rem master device size: 400

C:\Users\sybSID>rem errorlog: G:\sybase\SID\ASE-15_0\insta

ll\SID.log

C:\Users\sybSID>rem interfaces: G:\sybase\SID\ini

C:\Users\sybSID>rem

C:\Users\sybSID>"G:\sybase\SID\ASE-15_0\bin\sqlsrvr.exe" -d"G:\sybase\SID\sybsys

tem\master.dat" -sSID -e"G:\sybase\SID\ASE-15_0\install\SID.log" -i"G:\sybase\SB

D\ini" -M"G:\sybase\SID\ASE-15_0"

00:0000:00000:00000:2015/02/14 00:06:37.07 kernel dopen: open 'G:\sybase\SID\sy

bsystem\master.dat', No error

C:\Users\sybSID>-psa

'-psa' is not recognized as an internal or external command,

operable program or batch file.


so i am not sure what am i doing wrong here.

I also tried to run the service by running sqlsrvr.exe but i got no password generated in the output.

Please Advise.

Thanks

Sam