How can I resolve this error in Microsoft SQL Server Management Studio

xqnpmsa8 于 2023-04-10 发布在 SQL Server

关注(0)|答案(3)|浏览(173)

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)

sql-server

来源：https://stackoverflow.com/questions/59512297/how-can-i-resolve-this-error-in-microsoft-sql-server-management-studio

3条答案

按热度按时间

gupuwyp21#

just run this query :

USE yourdatabasename
GO
EXEC sp_changedbowner 'sa'

change yourdatabasename to database name you have!

赞(0）回复(0）举报 2023-04-10

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 .

赞(0）回复(0）举报 2023-04-10

ycggw6v23#

Yeah, It works absolutely.. change the database owner as a SA especially you're using non domain accounts while working with SQL server.

赞(0）回复(0）举报 2023-04-10

我来回答

How can I resolve this error in Microsoft SQL Server Management Studio

3条答案

相关问题

热门标签

最新问答