Can't Create Database Diagram Support Objects

I recently moved a database from SQL Server 2000 to 2005. Now when I try to
create a diagram I get the following error:
========================= Database diagram support objects cannot be installed because this database
does not have a valid owner. To continure, 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.
=========================
The database owner is 'sa'. I thought it might be a problem with an orphaned
user, but EXEC sp_change_users_login 'Update_One', 'sa', 'sa'; doesn't work
for 'sa'.
What can I do to resolve this problem?On Aug 29, 12:54 pm, Dan <dantheri...@.newsgroup.nospam> wrote:
> I recently moved a database from SQL Server 2000 to 2005. Now when I try to
> create a diagram I get the following error:
> =========================> Database diagram support objects cannot be installed because this database
> does not have a valid owner. To continure, 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.
> =========================> The database owner is 'sa'. I thought it might be a problem with an orphaned
> user, but EXEC sp_change_users_login 'Update_One', 'sa', 'sa'; doesn't work
> for 'sa'.
> What can I do to resolve this problem?
I seem to remember having the same issue and I could be wrong but:
Right click on the database, Properties, Options and set the
Compatibility Mode to SQL Server 2005 (90) and see if that works for
you.
There are implications of doing this, such as old SQL server syntax
will no longer be supported, so you will want to fully examine the
compatibilty of your database to SQL 2005 before doing this in your
production environment.|||Hi Dan,
This is a known issue. You can resolve it via:
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, please refer to the section 4.8.1 in this KB article:
SQL Server 2005 Readme and installation requirements
http://support.microsoft.com/default.aspx?scid=kb;EN-US;910228
Hope this helps. Please feel free to let us know if you have any other
questions or concerns. Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hi,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================