Symptom
- The following invalid login error occurs when executing a remote user procedure even though the user has the right permissions:
Could not execute statement.
Unable to connect to server 'sapserver': [Sybase][ODBC Driver][SQL Anywhere]Invalid user ID or password
SQLCODE=-656, ODBC 3 State="HY000"
Line 1, column 1
call test_rem.SysRemoteUsersRemote()
Press ENTER to continue...
- Once a user who owns remote procedure logs in, calling the procedure no longer returns the invalid login error
Read more...
Environment
- SAP SQL Anywhere 16
- SAP SQL Anywhere 17
Product
SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0
Keywords
client, authentication, log on, asa, anyhwere, extern_login_credential, SQL SECURITY DEFINER, Effective_user , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , BC-SYB-SQA-REM , SQL Anywhere - SQL Remote , Bug Filed
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.