Thanks William,
I included the appSettings section too as it mentions the database connection info as well.
much appreciated,
Ed
PS - it seems odd the error message says "Upgrade Error:" when it is actually not an upgrade but an initial installation.
<connectionStrings>
<!-- Connection String for SQL Server 2005 Express -->
<add name="SiteSqlServer" connectionString="Server=MAIL\SQLEXPRESS;Database=DotNetNuke500hc;uid=xxxx;pwd=xxxx);" providerName="System.Data.SqlClient" />
</connectionStrings>
<appSettings>
<!-- Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->
<add key="SiteSqlServer" value="Server=MAIL\SQLEXPRESS;Database=DotNetNuke500hc;uid=xxxx;pwd=xxxx);" />
<add key="InstallTemplate" value="DotNetNuke.install.config" />
<add key="AutoUpgrade" value="false" />
<add key="UseInstallWizard" value="false" />
<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-->
<!-- set UsePortNumber to true to preserve the port number if you're using a port number other than 80 (the standard)
<add key="UsePortNumber" value="true" /> -->
<add key="InstallationDate" value="1/2/2010" />
</appSettings>