Thursday, November 03, 2022

sql server database diagramm creation error

Error:

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.


Solution: Unter Db Eigenschaften, Files einen Owner eintragen siehe:

https://blog.sqlauthority.com/2021/10/21/sql-server-fix-error-cannot-execute-as-the-database-principal-because-the-principal-dbo-does-not-exist/#:~:text=the%20database%20principal.-,Cannot%20execute%20as%20the%20database%20principal%20because%20the%20principal%20%E2%80%9Cdbo,database%20properties%20for%20the%20file.


No comments: