2146162 - sp_addlogin raises error 567 "You must have the following role..." due to password required to set role 'sso_role' on. - SAP ASE

• When trying to login into an ASE server and using a login that have sso_role, getting error 11141:

Msg 11141, Level 16, State 1:
Server '<server_name>':
Password required to set role 'sso_role' on. 

• If "set role sso_role with passwd 'your_sso_role_password ' on " is not run, then error 567 is raised when one tries to add a new login:

1> sp_addlogin new_login, new_login_password
2> go
 
Msg 567, Level 16, State 1:
Server '<server_name>', Procedure 'sp_addlogin', Line 209:
You must have the following role(s) to execute this command/procedure: 'sso_role'. Please contact a user with the appropriate role for help.

SAP Adaptive Server Enterprise (ASE) - All versions

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem