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)

sony xperia 10 VI did not like the case

After iphone 16 I wanted to test an android and looks like sony xperia 10 VI is nice, which is 6.1 inches, but it was narrow and longer than...

  • 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...
  • 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 ...
  • pg_restore
    I know its been a long time I have not write anything. because I have not learn or done any new things. I dont want to write regular meaning...