Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
token
Posting Yak Master
133 Posts |
 Posted - 2006-02-17 : 16:42:59
|
Hi all,
This is the error message I have been experiencing ever since I upgraded from SQL 2000 to SQL 2005:
---------------------
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.
----------------------
I have altered the database owner to a valid log-in, but I don't understand the line that says "add the database support objects". What am I supposed to do?
Thanks for your help.
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-17 : 16:51:09
|
I guess you didn't try googling your error. I did and here's what I found on the MS link:
quote:
4.8.1 Considerations for Installing Database Diagram Support
The following limitations apply when installing database diagram support.
Database Diagram Support Cannot Be Installed Unless Database Compatibility Mode Is 2005 [90]
To install database diagram support in SQL Server Management Studio, databases must be in SQL Server 2005 database compatibility level. Database compatibility level can be reset after diagram support is installed. If the databases are not in 2005 compatibility level, the following error occurs when you attempt to install diagram support:
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.
To create database diagrams, change the database compatibility level to 2005, install database diagram support, and then return the database to the desired database compatibility level. For more information, search for "sp_dbcmptlevel" in SQL Server Books Online.
Installation of Database Diagram Support Objects Requires a Valid Logon Account
In SQL Server 2005, database diagram support objects will be installed on a database if a member of the db_owner fixed database role performs one of the following operations: • Expands the Database Diagrams folder
• Creates a new diagram
• Explicitly chooses to install the objects from the context menu
The installation of these support objects can fail on a database that has been attached or restored from another instance of SQL Server. This can occur when the database owner name (stored in the database) is not a valid logon for the instance of SQL Server that the database is being attached or restored to. Use the following Transact-SQL expression to change the database owner to a valid logon for the instance of SQL Server. Then, retry the database diagram operation. ALTER AUTHORIZATION ON DATABASE::database_name TO valid_login
And here's the link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;910228
Tara Kizer
aka tduggan |
 |
|
|
token
Posting Yak Master
133 Posts |
Posted - 2006-02-17 : 17:19:12
|
| Ahh thanks for that, its now fixed! Woo-hoo! I totally forgot about Google. I looked in three SQL Server 2005 books and couldn't find the solution. Your help is greatly appreciated Tara. |
|
|
|
|
|
|
After SQL2005 no more database diagrams