I love it when I can reply to my own posts; it means that I solved my own problem! In this case I'm not sure what I did differently but I have now upgraded my DNN 3.2.2 to DNN 4.0.2. The steps that I followed ar as follows:

1. Copied my production folder for my site to a development system. This folder contained the production DNN 3.2.2 files for the site.
2. Detached my database from SQL Server 2000 and copied the MDF and LDF files to the development system.
3. Re-Attached the database on the server so my production site would continue to work.
4. The remaining steps are now for the development system.
5. Created a virtual directory in IIS pointing to the folder I just created from the copy above.
6. Make sure that ASP.Net 2 is selected for the site
7. Attached the copied database in SQL Server 2000
8. Unzipped the DNN4.0.2 Install on top of the 3.2.2 folder.
9. Remaned the 3.2.2 web config to web.config.322
10. renamed release.config to web.config.
11. Edited the web.config and changed the database information per the installation docs.
12. Browsed to the site
13. The upgrade worked and when I tried to go to the portal I got the message "Nothing to update at this time".
14. Edited the web.config again and added the following to the AppSettings: <add key="InstallationDate" Value="10/10/2005" />
15. Browsed to the site again and it worked?

I will now try to upgrade the database from SS2000 to SS2005.

Ron

Hi Guys,

I too am interested in this answer.  I have installed .net 2.0 on the same server and will try upgrading this weekend as described above.  I have installed successfully the SQLExpress version of Sql server + msde successfully but cannot follow the documentation on where the username, password and database name appear in the web.config file. Sorry but the install doco is sadly lacking in this area :( Its becoming unwieldy)

Any ideas?

Conrad

http://www.whynotwebsites.com