User Cannot view database diagrams

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bassbuster - 29 Feb 2008 19:42 GMT

I am working with a fellow developer that cannot view database diagrams on
his machine. He can log into another machine and view them just fine.

Enterprise Manager has been removed, reinstalled and service packed to the
correct level.

Any quick fix ideas besides re-imageing the machine? Previous users of this
machine have had the same problems.

Reply to this Message

anxcomp - 29 Feb 2008 20:32 GMT

Are you using the same login on local and remote machine?

Permision?

Reply to this Message

bassbuster - 29 Feb 2008 21:08 GMT

Permissions are adequate. He can log into any other workstation and view the
diagrams.

We have it narrowed down to workstation issue.

> Are you using the same login on local and remote machine?
>
> Permision?

Reply to this Message

anxcomp - 29 Feb 2008 21:18 GMT

Understanding Database Diagram Ownership (Visual Database Tools)
http://msdn2.microsoft.com/en-us/library/ms186345.aspx

Reply to this Message

bassbuster - 29 Feb 2008 21:26 GMT

The issue is not one of permissions. The developer in question is a member of
the db_owner group.

He can access the diagrams from other workstations when he logs into them.

The issue is specific to the configuration of his workstation.

> Understanding Database Diagram Ownership (Visual Database Tools)
> http://msdn2.microsoft.com/en-us/library/ms186345.aspx

Reply to this Message

Roy Harvey (SQL Server MVP) - 29 Feb 2008 21:42 GMT

>The issue is not one of permissions. The developer in question is a member of
>the db_owner group.
>
>He can access the diagrams from other workstations when he logs into them.
>
>The issue is specific to the configuration of his workstation.

Be aware that part of the configuration of his workstation is who he
connects as. The registration includes options for either Windows or
SQL Server authentication.

Roy Harvey
Beacon Falls, CT

Reply to this Message