Thursday, February 16, 2012

Attaching Northwind (2000) into SQL Server 2005

I am trying to attach to the SQL Server 2000 sample Northwind database using SQL Server 2005. When I do the Database-->Attach using the GUI everything seems alright. I can open the Northwind database and see the usual listing of stuff.

However, when I click on the Database Diagrams, I get an error message stating "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 support objects."

I have tried repeatedly to get the ALTER AUTHORIZATION statement to work, all to no avail. I have restarted my machine, and the properties of the database is now saying that the owner is the same as the other databases I have, but I keep getting the error message.

What am I doing wrong here? How can I fix this?

Any help would be greatly appreciated.

Thank you.Did you already checked the link: http://msdn2.microsoft.com/en-us/library/ms186345.aspx

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

That worked perfectly.

Thank you!

No comments:

Post a Comment