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:

Anonymous said...

Thanks really helpful.
Hafiz

Abdul Waheed said...

Nice it works

Anonymous said...

Thanks !!!

Anonymous said...

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

Anonymous said...

Thanks a lot it worked like a charm

Anonymous said...

Gracias!!

Rizwan Hussain said...

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

Rizwan Hussain said...

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

Rizwan Hussain said...

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

Rizwan Hussain said...

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

Rizwan Hussain said...
This comment has been removed by the author.
Rizwan Hussain said...

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

Rizwan Hussain said...

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

Anonymous said...

Muchísimas gracias, amigo.

Asif Iqbal said...

It worked. Great.

Be-Bu Design said...

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.

Amastaneh said...

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

Anonymous said...

Thanks, this was a big help

Anonymous said...

Thanks. It works