Right click on the database, and select Properties. In order to create SQL Database Diagrams, you must use 'SA' as owner of the database. The whole premise of this article is incorrect. This error comes up if you are not using 'sa'.įor instance, I was getting this error even with my domain admin account which was also in the sysadmin role in SQL Server.Īfter connecting using 'sa' things worked just fine in the very latest version of SSMS. There is no indication this is a deprecated feature. Thus, if we are using SSMS 17 thru 18.0, we can just upgrade to 18.1 and newer versions and have this feature available again.'Ĭan you really do it in SSMS 18.0, for example? 'Fortunately, despite expectations, the 'Database Diagrams' feature is available with SSMS 18.1 and later. Restart the sql server is one of the solutions for this problem.
Hopefully this resolution will help someone else. Evidently the user interface gets confused. I was still experiencing this problem in 18.10.
Anything else I can try?Ĭlose the sql server is one of the solutions for this problem. I've gotten this error before, but I can usually save the diagram, close out and reopen and then it works. I made the diagram and every once in a while I update it by adding new tables to the structure.
I'm on SSMS 18.2 and I'm still getting this error.
