SSMS Cannot execute as database principal (Microsoft SQL Server, Error: 15517)

Question

Hello,

I have an .mdf file that I tried to attach in SSMS.  I am using (LocalDB)\MSSQLLocalDB (SQL Server 12.0.2569) The attach process seems to have completed successfully but when I want to make any changes at all I get the message:

"Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission (Microsoft SQL Server, Error: 15517)"

I can see the database diagram in VS when I create and Entity Framework Model but I am unable to perform any functions in SSMS like being able to establish relationships and the like.

I would appreciate some guidance on this.

Thank you.

Answer 1

Try this:

use [databasename]

GO

EXEC sp_changedbowner 'sa' 

GO

Answer 2

EXEC sp_changedbowner 'sa' 

Alternatively:

ALTER AUTHORIZATION ON DATABASE::YourDatabase TO sa;

---

Dan Guzman, Data Platform MVP, http://www.dbdelta.com

Answer 3

Do Graphically.

Database right click-->properties-->files-->select database owner-->select [sa]-- ok

---

Please Mark it as Answered if it answered your question OR mark it as Helpful if it help you to solve your problem.

Answer 4

Thank you all very much.  That is very helpful.

Answer 5

Finally,  where can I find more information on sp_ command editor?

Thanks

Answer 6

Hi Geol4549,

I’m not quite following here, could you please elaborate more? Are you looking for a list of system stored procedures? If so, please refer to this link.

If you have any other questions, please let me know.

Regards,
Lin

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 7

Is this what you are looking for?

https://msdn.microsoft.com/en-us/library/ms178630.aspx

Answer 8

Thank you, that worked.

Answer 9

Thank you

Answer 10

Thanks a lot! It worked.

Answer 11

thank you very much