Symptom
- SAP system does not work due to the following error in the developer trace:
(102) [42000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'execute.'.
<if user_name() != '<sid>' execute as login = suser_sname(suser_sid('<sid>')) with no revert> failed -- connect terminated
- The <sid> in the error is lower case
Read more...
Environment
- Netweaver
- MS SQL Sever database
Product
SAP ERP 6.0
Keywords
lower case, Incorrect syntax near 'execute.' , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.
SAP Knowledge Base Article - Preview