Cannot execute as the database principal (MS SQL server error 15517)

Question

0.00/5 (No votes)

See more:

Hello,

I have a small database (.mdf)file which I attached in SSMS so that I can see the tables in the Object Explorer. However I am unable to create Database Diagram for this database and I receive and error each time I attempt to do that. So I can't establish any relationships or perform any action.

ERROR: Cannot execute as the database principal because the principal "dbo" does not exist. This type of principal cannot be impersonated or you don not have permission. (MSSQL Server Error 15517)

In Visual Studio I can open the database as an ADO.Net Entity Framework Model but cannot create any relationships there either. So, the database is a group of unrelated tables, that are more-or-less useless.

Any constructive suggestions would be helpful.

Thanks.

What I have tried:

I have recreated the tables several times, but have not entirely recreated the database from scratch.

Posted 1-Jan-17 9:05am

RAFish0404

Updated 1-Jan-17 18:03pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Suvendu Shekhar Giri · Answer 1 · 2017-01-01T18:03:00

Try giving a database owner to your database. That resolves the error for me in the past.

If you still get error, please check following threads, if these help resolve your issue -
sql server - Cannot execute as the database principal because the principal "dbo" does not exist - Database Administrators Stack Exchange[^]
sql server - Cannot execute as the database principal because the principal “guest” does not exist - Database Administrators Stack Exchange[^]

Hope, it helps :)