I've run into a major problem upgrading my DotNetNuke 4.9 site from SQL Server 2000 to SQL Server 2005. My hosting provider required me to backup the SQL Server 2000 database then delete it so they could create a SQL Server 2005 database for me. I did that, then restored the backup to the SQL Server 2005 database. So far, so good. I can see all the tables, etc. in SQL Server 2005.

The problem is that now I think I have an orphaned database username. In the SQL Server 2000 database, I believe my login matched the database username. The database was named "MyDatabase", and the login for SQL Server and the username for "MyDatabase" were both "MyDatabaseAdmin01". I used "MyDatabaseAdmin01" as the uid in my web.config connection string.

When they setup my SQL Server 2005 database, they set the SQL Server login to "MyDatabase", matching the name of the database. However, I think all the permissions/schemas etc. are controlled by the username ""MyDatabaseAdmin01".

Does this make sense, and does anyone know how to fix it?

Unfortunately, this is the part I'm not clear on, and I'm having trouble explaining it to the tech support people. I am unclear as to under SQL Server 2000, what it means to be a dbo, and in SQL Server 2005, they're use of schemas. Basically, I want the exact same setup, (login, username, ownership) in SQL Server 2005 as I had in SQL Server 2000. Communicating that with them would have been comedic, if it hadn't been so late at night and my site was down the entire time.