Can not create Database Diagram - Could not obtain information about Windows NT Group/User [duplicate]
Asked Answered
O

1

6

I'm using a Local MS SQL Database, the database was created automatically using entity framework. The database is created with out any errors.

However when I use Microsoft Managment studio to try and create a database diagram I get the following error:

enter image description here

Even when I login as the SA user I still get the same error, any ideas on why this is happening and how to fix this error.

Obstinacy answered 12/2, 2020 at 13:38 Comment(3)
#25846336Quart
That link basically says to change the DB owner to sa. Fine. But why does sa need to be owner to create a diagram? In my case my machine is AzureAD Joined, but not Domain Joined (dsregcmd /status)Titty
No, it says that you must be logged in in your domain.Elliellicott
E
-3

sql 2019 - Change the owner to sa enter image description here

Enhanced answered 3/12, 2022 at 11:18 Comment(1)
Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.Stableman

© 2022 - 2024 — McMap. All rights reserved.