Looking for a JavaEE Architect or Potential Tech Co-Founder?
Please don't hesitate to contact me.

Database diagram support objects cannot be installed because this database does not have a valid owner

I encountered the error below when creating a diagram in the 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."

Solution:
Execute the following line in SQL Server Management Studio Express Query
ALTER AUTHORIZATION ON DATABASE::DATABASE_NAME TO "Your_User"
Database diagram support objects cannot be installed because this database does not have a valid owner Database diagram support objects cannot be installed because this database does not have a valid owner Reviewed by Edward Legaspi on Thursday, February 03, 2011 Rating: 5

No comments:

Powered by Blogger.