SQL diagram erorr

minoru mineta 21 Reputation points
2022-11-07T21:14:49.147+00:00

when I try to click new database diagram, it pops erorr.

SQL Server | Other
{count} votes

Accepted answer
  1. PandaPan-MSFT 1,931 Reputation points
    2022-11-10T07:34:45.797+00:00

    Hi @minoru mineta ,
    Right click your database and select properties---choose file---change the owner name into sa
    258998-image.png


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment"

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 47,441 Reputation points
    2022-11-08T08:01:03.927+00:00

    In the screenshot I see you logged on to SQL Server with local account "DESKTOP\Admin", the error complaints about user NARUTO\Admin
    Have you renamed your machine? Or is the database from a different SQL Server? If last, remove the database user.

    A known issue with diagram is, then an error can occur if the database owner is a different one the the system admin "sa"; change it if it's not.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.