How to 'lock' and 'unlock' 'sa' login - SAP ASE

Following errors  facing while login to isql in sybase DB with 'sa' account .

*  unable to connect as user 'sa'

*  ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

*  isql -Usa -SSID -X
   Msg 4002, Level 14, State 1:
   Server 'SID'
   :Login failed.
   CT-LIBRARY error:

For security reasons 'sa' login is locked for sybase ASE business suits and BW , hould only be used for maintenance if advised by support.

• Never 'unlock' 'sa' login for normal activities instead use 'sapsa' account for normal activities including backups.
• Only for maintenance if you need to use 'sa' login, you will need to first unlock it.

Syntax  for sa unlock :-
isql -Usapsso -P<password> -S<SID> -X
> sp_locklogin 'sa', 'unlock'
> go

Remember to 'lock' 'sa' login once the maintenance is complete

Syntax for lock sa account :-

> sp_locklogin 'sa', 'lock'

> go

Use sp_locklogin to lock and unlock accounts . You must be a system security officer (sapsso) to use sp_locklogin.

The syntax is:

Lock -
sp_locklogin 'login_user_name', 'lock'

Unlock -
sp_locklogin 'login_user_name', 'unlock'

Also Read,
Sybase

Share this

Basis Genie