I've done several of these in the past week because of IE7, so I can almost do them in my sleep. Here is what you have to do:
<connectionStrings>
DELETE THIS PART OF THE CODE IF YOU DON'T USE EXPRESS
<!-- Connection String for SQL Server 2005 Express -->
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
<!-- Connection String for SQL Server 2000/2005 --> ADD THE END OF COMMENT TO END OF THIS LINE
<add
name="SiteSqlServer"
connectionString="Server=(local);Database=DotNetNuke;uid=dtsobel;pwd=*****;"
providerName="System.Data.SqlClient" />
REMOVE THIS END OF COMMENT
-->
</connectionStrings>
<appSettings>
DELETE THIS PART OF THE CODE IF YOU DON'T USE EXPRESS
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"/>
<!-- Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules --> ADD THE END OF COMMENT TO END OF THIS LINE
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=dtsobel;pwd=*****;"/>
REMOVE THIS END OF COMMENT
-->
<add key="InstallTemplate" value="DotNetNuke.install.config" />
<add key="AutoUpgrade" value="true" />
<add key="InstallMemberRole" value="true" />
<add key="ShowMissingKeys" value="false" />
<add key="EnableWebFarmSupport" value="false" />
<add key="EnableCachePersistence" value="false"/>
<add key="HostHeader" value="" /><!-- Host Header to remove from URL so "www.mydomain.com/johndoe/Default.aspx" is treated as "www.mydomain.com/Default.aspx" -->
<add key="RemoveAngleBrackets" value="false" /><!--optionally strip angle brackets on public login and registration screens-->
<add key="PersistentCookieTimeout" value="0" /><!--use as persistent cookie expiration. Value is in minutes, and only active if a non-zero figure-->
</appSettings>
further down....
<system.web>
<machineKey
REPLACE THE KEYS FROM YOUR OLD WEB.CONFIG FILE INTO THESE PARTS SO THE DATABASE CAN VALIDATE YOUR CALLS
validationKey="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902"
decryptionKey="F9D1A2D3E1D3E2F7B3D9F90FF3965ABDAC304902F8D923AC"
decryption="3DES"
validation="SHA1"/>
further down....
CHANGE RemoteOnly TO Off SO THE UPDATING WILL DISPLAY TO THE SCREEN
<!-- permits errors to be displayed for remote clients -->
<customErrors mode="Off"/>
Save the file. Make sure you are on ASP 2 and then run Default.aspx at the top level of your website. This should fix your problem.
- LL