2348747 - SAP Startup fails with SQL error 15406

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.

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

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 , BW-SYS-DB-MSS , BW on Microsoft SQL Server , BC-CST-STS , Startup Service , BC-INS-NT , SAP Netweaver based Solutions on Windows , Problem