Exception: the database does not have a valid owner. Therefore, the database relational diagram support object cannot be installed.

Source: Internet
Author: User

When you restore the database backed up from another machine to your machine and click the database relationship diagram of this database in SSMs, the following prompt is displayed:

The database does not have a valid owner, so you cannot install the database relational diagram support object. To continue, first set the database owner to a valid login name using the "file" page or the alter authorization statement in the "database properties" dialog box, and then add a database relational diagram support object.

The database is determined to have a database relationship diagram. The following two methods are provided: the first method is difficult to use after several attempts, and the second method is successful. Specifically, run the following command in SSMs:

Alter authorization on Database: mydbname to sa

Modify mydbname to the actual database name, and set the owner to sa.

For detailed parameters of alter authorization, refer to the following address:
Http://msdn2.microsoft.com/zh-cn/library/ms187359.aspx

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.