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

11 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!!

sreenath said...

thank you

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...
This comment has been removed by the author.