[SQL]Cannot execute as the database principal because the principal “xxxx” does not exist

You are executing a statement in Microsoft SQL Server but end up with below error message,

Error message: DBSL error 99 (db code 15517): 
Cannot execute as the database principal because the principal "xxxx" does not exist, 
this type of principal cannot be impersonated, or you do not have permission.

Solution

Right click on the database and select Properties. Go to Files and maintain the Owner field as sa.

You May Also Like

Leave a Reply?