I have created a database online clinic management system having 10 tables. Now I want to create a database diagram for this database but I'm getting the following error. Please share your knowledge to resolve this error.Thank you.
TITLE: Microsoft SQL Server Management Studio
Could not obtain information about Windows NT group/user 'HAIER-PC\92347', error code 0x534. (Microsoft SQL Server, Error: 15404)
3条答案
按热度按时间gupuwyp21#
just run this query :
change yourdatabasename to database name you have!
deyfvvtc2#
I have found the solution. Just go to databases. Select your database.Go to Properties. Open Files and modify owner to [sa].Its working .
ycggw6v23#
Yeah, It works absolutely.. change the database owner as a SA especially you're using non domain accounts while working with SQL server.