SAP Knowledge Base Article - Preview

3050037 - [Microsoft][ODBC Driver ## for SQL Server][SQL Server]Cannot execute as the server principal because the principal "sid_shd" does not exist, this type of principal cannot be impersonated, or you do not have permission.

Symptom

Shadow instance fails to start during upgrade. The errors could be in the following patterns:

  • Cannot execute as the server principal because the principal "sid_shd" does not exist, this type of principal cannot be impersonated, or you do not have permission.
    <if user_name() != '<sid>_shd' execute as login = suser_sname(suser_sid('<sid>_shd')) with no revert> failed -- connect terminated
  • ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 8909]
    Incorrect syntax near 'execute.'.
    <if user_name() != '<sid>_shd' execute as login = suser_sname(suser_sid('<sid>_shd')) with no revert> failed    connect terminated


Read more...

Environment

SAP Netweaver based application server 
Microsoft SQL Server

Keywords

_shd, shd, shadow instance server system, 'Incorrect syntax near 'execute.' MAIN_SHDRUN  , KBA , BC-DB-MSS-SYS , Database Interface/DBMS for MSS , 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.