This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 82%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have window authentication in SSMS, i installed the SSMS as administrator but still i cant open diagram to my tables the server name is localhost, what can i do
This is the error message:
TITLE: Microsoft SQL Server Management Studio
Could not obtain information about Windows NT group/user 'CS-ROBOTICS\yonatan.daiti', error code 0x54b. (Microsoft SQL Server, Error: 15404)
For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-15404-database-engine-error
BUTTONS:
OK
Hi @יהונתן דאיטי,
We haven't heard any response from you yet.
Is this issue solved now? If you have any questions, please feel free to share with us.
May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
Hi @יהונתן דאיטי,
Do you have further question on this, could we offer more support?
Could you please let us know how your issue regarding I want to show the diagram of tables in my database is going?
And don't forget to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding.
Best regards,
Lucy Chen
Hi @יהונתן דאיטי,
Could you please tell us if there is any new progress on this issue?
We are still very concerned about your issue!
In addition, I don't want to nag you, but maybe the answers are helpful. May I humbly suggest that please accept Answer if they helped.
Your action would be helpful to other users who encounter the same issue and read this thread.
The links and methods we provide will also help them resolve their issue or follow up this issue with us together!
Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!
Best regards,
Lucy Chen
Do you mean you want to create a database diagram (ERD)?
There is a known issue, th function fails if not the SysAdmin account "sa" is the database owner; you have to change it.
There is a known issue, th function fails if not the SysAdmin account "sa" is the database owner; you have to change it.
Solution is correct: change the database owner. However, it has nothing to do with sa. But this is an error that often occurs when you restore a database from one instance to another. This can easily lead to a mismatch between the owner according to sys.databases and which login the user dbo in the database maps to.
Hi @יהונתן דאיטי,
Thank you for your reaching out and welcome to Microsoft Q&A!
For the error message:
Could not obtain information about Windows NT group/user 'CS-ROBOTICS\yonatan.daiti', error code 0x54b. (Microsoft SQL Server, Error: 15404)
Please refer to the link in error message provided and verify the information below:
If this error is the result of a lack of a full trust relationship between the SQL Server service account and the domain of the Windows account, one of the following actions can resolve the error:
In addition, we can get the information from this official document:
Although any user with access to a database can create a diagram, once the diagram has been created, the only users who can see it are the diagram creator and any member of the db_owner role. If the diagram creator is part of a user group and not a member of the db_owner role then they require their own login to view the diagram.
Feel free to share your issue here if you have any concerns.
Best regards,
Lucy Chen
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
https://docs.microsoft.com/en-us/answers/support/email-notifications
Hi @יהונתן דאיטי,
We haven't heard any response from you yet.
Is this issue solved now? If you have any questions, please feel free to share with us.
May I humbly suggest that you accept Answer if they helped. It may help others who see the thread in seek of help.
Your action would be helpful to other users who encounter the same issue and read this thread. :)
Thanks for your understanding. Wish you have a nice day!
Best regards,
Lucy Chen
Hi @יהונתן דאיטי,
Could you please tell us if there is any new progress on this issue?
We are still very concerned about your issue!
In addition, I don't want to nag you, but maybe our answers are helpful. May I humbly suggest that please accept Answer if they helped.
Your action would be helpful to other users who encounter the same issue and read this thread.
The links and methods we provide will also help them resolve their issue or follow up this issue with us together!
Thanks for your understanding. Your encouragement and recognition are the driving force for our progress!
Best regards,
Lucy Chen