MSSQLSERVER_15517
Details
| Product Name | SQL Server |
| 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 cannot be impersonated, or you do not have permission. |
User Action
Use the name of an existing principal or get the IMPERSONATE permission on that principal.
15517 can also occur after performing an attach and restore of a database by someone other than the original database owner. To resolve this error, change the db_owner to a login on your server, by running the following command:
ALTER AUTHORIZATION ON DATABASE:: DBName TO [NewLogin]