15517

Product

Name

Event ID

15517

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic

Name

SEC_CANNOTEXECUTEASUSER

Message Text

Cannot execute as the database principal because the principal ”

principal

” does not exist,

this type of principal can’t be impersonated, or you do not have permission.

This error typically occurs because Microsoft SQL Server can’t get the information about the

execution context of the principal that’s specified in a user statement or module by using the

statement.

Your login information Security Identifier (SID) is automatically saved when you create a

database on a SQL Server instance as the database owner in the corresponding database row

in the

table and for the

user item in the

table

within the database.

The statements or modules that use the

clause will work as expected if the

SID entry that’s stored for the dbo user is valid.

ﾉ

Expand table

７

Note

EXECUTE AS sys.databases dbo sys.database_principals
EXECUTE AS OWNER