Microsoft SQL Server Management Studio Diagram Error
Problem/Error/Issue
Microsoft SQL
Server Management Studio Database
diagram failed to open when you connect to SQL Server Database remotely from
another computer
Solution:
The error above caused due to the
following reason
The MSSMS Database Diagram does not
have a valid owner
In SQL Server Management Studio do
the following:
- Right Click on your database, choose properties
- Go to the Options Page
- Go to the Files Page
- Enter "sa" or "other sql server user
which is not mapped into said database diagram"
- Hit OK
After doing this, You will now be
able to access the Database Diagrams.
Microsoft SQL Server Management Studio Diagram Error
Reviewed by Martin
on
Wednesday, December 07, 2016
Rating:
No comments: