Hi, we do not have the SA password and need to reset the unknown pwd. Can someone please help?
isql -S SybaseServer
linux:/opt/sybase # isql -S SybaseServer
Msg 4002, Level 14, State 1:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
3.) Logging in after lost password
If your site encounters any of these situations:
• All System Administrator login accounts are locked.
• All System Security Officer login accounts are locked.
• The password for sa_role or sso_role has been lost,
You can restart Adaptive Server with the dataserver -plogin_name parameter, which allows you to set a new password for these accounts and roles if there is no way to recover a lost password. login_name is the name of the user or the name of the role (sa_role or sso_role) whose password needs to be reset.
This allows you to set a new password for these account if there is no way to recover a lost password.
I have read that linux:/ # dataserver -plogin_name
dataserver: Server name missing or is longer than supported. Proceeding with 'SYBASE' as Servername.
00:0000:00000:00000:2013/07/28 03:52:52.95 kernel Attempt to open device d_master failed.
00:0000:00000:00000:2013/07/28 03:52:52.95 kernel dopen: open 'd_master', No such file or directory