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:
Thanks really helpful.
Hafiz
Nice it works
Thanks !!!
i got this error man but your post helped i changed owner to sa it worked for me thanx
Jap Auto Parts
Thanks a lot it worked like a charm
Gracias!!
thank you
before this it was a problem after this it is very easy staff -- thanks
before this it was difficult after this it is too easy --- thanks
before this it was difficult after this it is too easy THANKS
Post a Comment