Sunday, June 22, 2008

Cannot add diagram to SQL Server 2005 DB: Database diagram support objects cannot be installed because this database does not have a valid owner.

I was having same problem which explained in tha linked page. but this page did not solve my problem. how I solve this issue:
1- download sql management studio express
2- in the tree open security node and right click on "sa" user and enable "sa" login.
after that I easily design my database in diagram.

Cannot add diagram to SQL Server 2005 DB: Database diagram support objects cannot be installed because this database does not have a valid owner.
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

C# scan cs file and find variables values and names

using Microsoft . CodeAnalysis ; using Microsoft . CodeAnalysis . CSharp ; using Microsoft . CodeAnalysis . CSharp . Syntax ; using Xunit . ...

  • Yeni nesil hacker'lar: Edwin Pena | Olympos Security
    Yeni nesil hacker'lar: Edwin Pena | Olympos Security koptum okuyunca yazılımcılar ve pazarlamacılar bu kadar kısa ve özlü bir hikayeyle ...
  • weblogic 12 to 11 ejb connection problem
    if you have wl11 ejb server and in that environment generated ejb client and deploy to wl12 it will give you this exception java.lang.NoSu...
  • odd string diff
     https://leetcode.com/problems/odd-string-difference/ Beats 19.92% of users with Java   class Solution { public String oddString ( S...