SAP Knowledge Base Article - Preview

2348747 - SAP Startup fails with SQL error 15406

Symptom

The startup of an SAP system does not work due to the following error in the developer trace:

C  (15406) [42000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot execute as the server principal because the principal "prd" does not exist, this type of principal cannot be impersonated, or you do not have permission.
C  <if user_name() != 'prd' execute as login = suser_sname(suser_sid('prd')) with no revert> failed -- connect terminated
B  ***LOG BY2=> sql error 15406  performing CON [dbsh         1246]
B  ***LOG BY0=> Cannot execute as the server principal because the principal "prd" does not exist, this type of principal cannot be impersonated, or you do not have permission. [dbsh         1246]
B  ***LOG BY2=> sql error 15406  performing CON [dblink       544]
B  ***LOG BY0=> Cannot execute as the server principal because the principal "prd" does not exist, this type of principal cannot be impersonated, or you do not have permission. [dblink       544]
M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1527]

Consider for the above example, the SID of the system is PRD and the database schema is prd.


Read more...

Environment

  • SAP NetWeaver based systems;
  • MS SQL Server 2008 and higher;

Product

SAP NetWeaver all versions

Keywords

SQL10, SQL11, SQL12, SQL13, mssql, ms sql, msql, ms_sql, copy, copying, installing, error while, steps, phases, executed, not executed, startup, start up, starting, starting up, error during, cannot start, is not going up, isnt going up, SWPM, Software Provisioning Manager, system copy, sid, SID, principal, Login, Authentication, schema, does not exist, impersonated, you do not have permission, type, ODBC Driver, SNAC, execute as, terminated , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-OP-NT , Windows , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , BC-INS-NT , Installation Windows , BW-SYS-DB-MSS , BW Microsoft SQL Server , BC-CST-STS , Startup Service , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.