Symptom
- 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.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) - All versions
Product
SAP Adaptive Server Enterprise all versions
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.