Hi,
I have the site in a server Windows 2003 with DNN 5.2.2 and SQL Server 2005 STD. All works well.
I want to move the site in a server Windows 2008 R2  with SQL Server 2008 R2.
I have done this:
1) installed a standard site dnn 5.2.2 in new server : All ok.
2) Restore of the backup database SQL 2005 in SQL 2008 R2 64Bit: ok , it has finished with: The restore of database 'MYDATABASE' completed succesfully
3) I copy the web directory  from the server 2003 to the server 2008
4) Change the sql connection strings and the machinekey in web.config ( the machinekey  is that of the dnn 5.2.2 std that have worked )
5) Browse to http://localhost/  and appears:

Upgrading DotNetNuke
Current Assembly Version: 05.02.02
Current Database Version: 04.09.05

Upgrade Status Report
00:00:00.076 - Upgrading to Version: 05.02.02
00:00:01.655 -   Executing Script: 05.00.00.SqlDataProvider Success
00:00:06.020 -   Executing Script: 05.00.01.SqlDataProvider Success
00:00:00.127 -   Executing Script: 05.01.00.SqlDataProvider Success
00:00:01.810 -   Executing Script: 05.01.01.SqlDataProvider Success
00:00:02.018 -   Executing Script: 05.01.02.SqlDataProvider Success
00:00:02.026 -   Executing Script: 05.01.03.SqlDataProvider Success
00:00:02.075 -   Executing Script: 05.01.04.SqlDataProvider Success
00:00:02.088 -   Executing Script: 05.02.00.SqlDataProvider Success
00:00:03.235 -   Executing Script: 05.02.01.SqlDataProvider Success
00:00:03.470 -   Executing Script: 05.02.02.SqlDataProvider Success
00:00:03.561 -   Executing Application Upgrades: 05.00.00 Success
00:00:10.385 -   Executing Application Upgrades: 05.00.01 Success
00:00:10.441 -   Executing Application Upgrades: 05.01.00 Success
00:00:14.025 -   Executing Application Upgrades: 05.01.01 Success
00:00:14.078 -   Executing Application Upgrades: 05.01.02 Success
00:00:14.078 -   Executing Application Upgrades: 05.01.03 Success
00:00:14.383 -   Executing Application Upgrades: 05.01.04 Success
00:00:14.384 -   Executing Application Upgrades: 05.02.00 Success
00:00:14.559 -   Executing Application Upgrades: 05.02.01 Error!
00:00:14.673 -   Executing Application Upgrades: 05.02.02 Success
00:00:14.676 -   Cleaning Up Files: 05.00.00 Success
00:00:14.678 -   Cleaning Up Files: 05.00.01 Success
00:00:14.678 -   Cleaning Up Files: 05.01.00 Success
00:00:14.678 -   Cleaning Up Files: 05.01.01 Success
00:00:14.678 -   Cleaning Up Files: 05.01.02 Success
00:00:14.678 -   Cleaning Up Files: 05.01.03 Success
00:00:14.678 -   Cleaning Up Files: 05.01.04 Success
00:00:14.679 -   Cleaning Up Files: 05.02.00 Success
00:00:14.679 -   Cleaning Up Files: 05.02.01 Success
00:00:14.679 -   Cleaning Up Files: 05.02.02 Success
00:00:14.680 -   Updating Config Files: 05.00.00 Success
00:00:14.682 -   Updating Config Files: 05.00.01 Success
00:00:14.682 -   Updating Config Files: 05.01.00 Success
00:00:14.682 -   Updating Config Files: 05.01.01 Success
00:00:14.682 -   Updating Config Files: 05.01.02 Success
00:00:14.682 -   Updating Config Files: 05.01.03 Success
00:00:14.683 -   Updating Config Files: 05.01.04 Success
00:00:14.683 -   Updating Config Files: 05.02.00 Success
00:00:14.683 -   Updating Config Files: 05.02.01 Success
00:00:14.683 -   Updating Config Files: 05.02.02 Success
00:00:14.683 - Performing General Upgrades
00:00:14.791 - Installing Optional Modules:
00:00:14.792 - Installing Optional Skins:
00:00:14.792 - Installing Optional Containers:
00:00:14.792 - Installing Optional Languages:
00:00:14.792 - Installing Optional Providers:
00:00:14.793 - Installing Optional AuthSystems:
00:00:14.793 - Installing Optional Packages:

Upgrade Complete

Click Here To Access Your Portal
------------------

All the lines: success but a line: Error:

00:00:14.559 -   Executing Application Upgrades: 05.02.01 Error!

Click to Access You Portal. The portal appears  but I don't access with the password of root !!

Why has it made the updating from version 04.09.05 to 05.02.02 ?  The site of origin is already in version 05.02.02

What can I do?

Thanks

As it is possible that a dnn version 5.2.2 transferred on sql 2008 ask an updating from version 4.9 ? Perhaps it was a web directory that has had the updating from  4.9 to 5.2 and they have remained some fileses of the 4.9 ?

Hi Sebastian.
You are right, the database was wrong!
Now I have tried with the correct database, the sites are seen by the browser,  but the passwords of hots and Admin don't work!

Why?
What can I do?
Thanks