I am trying to upgrade my database from SQL2000 to SQL2005 and I've come across something strange that I hope someone has seen before (and resolved)

I updated the database the same as I have done others.:

1. Backup the database in SQL2000
2. Create a new database on the SQL2005 server
3. Restore the database into SQL2005
4. Re-create the user and give them dbo rights to the database
5. Re-point the DNN install

All of this worked fine until I tried testing the 5.1.4 upgrade (from 4.8.4)  All the database upgrades failed.  Looking at the logs, they referenced a different user account than the one it should be.

NCGTDNNUSER is configured as follows:

• dbo to the database in SQL2000
• dbo to the database in SQL2005
• Has a valid login on the server in both SQL2000 and SQL2005
• Is the UID in the web.config file

NCGTOURDNN is configured as follows:

• dbo to the database in SQL2000
• dbo to the database in SQL2005
• Does NOT have a valid login on the server in either SQL2000 or SQL2005

I tried to delete the user in SQL2005 and it fails telling me that the user owns a schema in the database.  Looking at the database schema, I find one called NCGTOURDNN.  Trying to delete that and it fails telling that the schema is being referenced by an object "davetest".  The only reference to davetest that I could find was the end of an portalalias, which I deleted (sitename/davetest).  Still no luck deleting the schema, it still says that it is being referenced by davetest.

If anyone has a clue what I can do to fix this, it would really be appreciated.

Cheers

Hi Dave,

Thanks for posting your solution. I have an old SBS2003 box still running SQL Server 2000 and a couple of test DNN sites there. What you have posted may very well help me with some of my future issues...

Cheers,

Trev.