SAP Knowledge Base Article - Preview

3768771 - Dispatcher stops at startup with sql error 15406 and db_connect_error on sql server

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

SAP ERP all versions

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.