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

  • MSSQLSRV shadow instance / system / server fails to start
  • [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.
           <if user_name() != 'sid_shd' execute as login = suser_sname(suser_sid('sid_shd'))
            with no revert> failed -- connect terminated


Read more...

Environment

MS SQL Server 2012 (SP4-OD) (KB4091266) - 11.0.746 SP4 Enterprise Edition /MS Cluster
   MS SQL Version: 11.0.7469.6

SUM upgrade SAP ABAP NW 7.4 to 7.5

Keywords

_shd shd shadow instance server system , 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 ONE Support launchpad (Login required).

Search for additional results

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