Symptom
- During system startup, the dispatcher (disp+work.exe) process starts and then stops automatically.
- Work processes terminate during initialization.
- dev_w0 shows following error message:
----
C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect)
C (15406) [42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Cannot execute as the server principal because the principal "<sid>" does not exist, this type of principal cannot be impersonated, or you do not have permission.
C <if user_name() != '<sid>' execute as login = suser_sname(suser_sid('sid')) with no revert> failed -- connect terminated
B ***LOG BY2=> sql error 15406 performing CON
B ***LOG BY0=> Cannot execute as the server principal because the principal "<sid>" does not exist, this type of principal cannot be impersonated, or you do not have permission.
----
- In some cases, “Error 18456” may also be observed in SQL-related logs.
Read more...
Environment
- Product: SAP NetWeaver 7.x (SAP ERP)
- Microsoft SQL Server 20xx "Enterprise Edition" in SAP NetWeaver Products
Product
Keywords
dispatcher stops, db_connect_error, sql error 15406, error 18456, dev_w0, startup failure, mssql server, sql server, sap netweaver, sapservicesid, service log on as, permissions, work directory, jstart stops, windows service , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft SQL Server , 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