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.

All Forums  Other Forums  SQL Server 6.5 \ SQL Server 7.0  SQL 7 -> 2005 Upgrade Advisor problem

Author  Topic  HDLCS Starting Member 1 Post Posted - 2008-10-24 : 13:29:36 I am upgrading a SQL 7.0 instance to 2005. I am using a fresh 2005 install on a new machine. When running Upgrade Advisor I am told that there are duplicate SID's The Duplicate SID in question - Administrator. There are two dbo entries in the USERS section of the database- both with Administrator as the Login name. Attempts to delete either meet with "Can not delete because the user owns objects" Other than the obvious, that Administrator shouldn't be the dbo- how can I manage to delete one of the dbo entries so the upgrade can run smoothly? Thanks, Hal