Sql 2005 Database diagram support objects cannot be installed because this database does not have a ...

最新推荐文章于 2024-10-02 00:27:17 发布

weixin_30552811

最新推荐文章于 2024-10-02 00:27:17 发布

阅读量81

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/joechen/archive/2009/05/08/1452544.html

版权

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

Problem

After restoring DB in SQL Server 2005 db most of the time I get the following error:

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.

1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
4. Goto the Files Page
5. Enter "sa" in the owner textbox.
6. Hit OK


But for some reason today the above steps did not work.... After googling for a while I quickly found

the following suggestion which worked just fine for me....

转载于:https://www.cnblogs.com/joechen/archive/2009/05/08/1452544.html