Pages

▼

March 18, 2011

database does not have a valid owner

Error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.
------------------------------
BUTTONS:
OK
------------------------------

Solution:
1. Right Click on your database, choose properties
2. Goto the Files
3. Change the owner textbox to "sa"
4. Press OK
5. Enjoy
@

19 comments:

  1. AnonymousJanuary 26, 2012 7:06 AM

    Thanks really helpful.
    Hafiz

    ReplyDelete
  2. Abdul WaheedMay 28, 2012 6:11 AM

    Nice it works

    ReplyDelete
  3. AnonymousJune 01, 2012 4:27 PM

    Thanks !!!

    ReplyDelete
  4. AnonymousJune 21, 2012 12:11 PM

    i got this error man but your post helped i changed owner to sa it worked for me thanx
    Jap Auto Parts

    ReplyDelete
  5. AnonymousJune 28, 2012 6:42 PM

    Thanks a lot it worked like a charm

    ReplyDelete
  6. AnonymousJuly 22, 2012 6:28 PM

    Gracias!!

    ReplyDelete
  7. Rizwan HussainApril 21, 2013 2:36 AM

    before this it was a problem after this it is very easy staff -- thanks

    ReplyDelete
  8. Rizwan HussainApril 21, 2013 2:38 AM

    before this it was difficult after this it is too easy --- thanks

    ReplyDelete
  9. Rizwan HussainApril 21, 2013 2:39 AM

    before this it was difficult after this it is too easy THANKS

    ReplyDelete
  10. Rizwan HussainApril 21, 2013 2:41 AM

    before this it was difficult after this it is too easy THANKS

    ReplyDelete
  11. Rizwan HussainApril 21, 2013 2:42 AM

    This comment has been removed by the author.

    ReplyDelete
  12. Rizwan HussainApril 21, 2013 2:44 AM

    before this it was difficult after this it is too easy THANKS

    ReplyDelete
  13. Rizwan HussainApril 21, 2013 2:46 AM

    before this it was difficult after this it is too easy THANKS

    ReplyDelete
  14. AnonymousSeptember 26, 2013 2:00 PM

    Muchísimas gracias, amigo.

    ReplyDelete
  15. Asif IqbalNovember 01, 2013 1:44 AM

    It worked. Great.

    ReplyDelete
  16. Be-Bu DesignFebruary 11, 2014 2:29 AM

    u r crazy man, i have 2 hour that i am looking and trying to fix that, with ur instructions with 4 hops i have fix that, thank u veryy muchh.

    ReplyDelete
  17. AmastanehFebruary 11, 2014 3:22 AM

    @Be-Bu: YW, This is awesome and You made my day :-)

    ReplyDelete
  18. AnonymousMay 04, 2014 5:58 AM

    Thanks, this was a big help

    ReplyDelete
  19. AnonymousMay 11, 2015 12:00 PM

    Thanks. It works

    ReplyDelete