Having some trouble getting DNN 04.08.04 installed. See error below followed by connection strings and appsettings.

All suggestions welcome,

Error Installing DotNetNuke

Current Assembly Version: 04.08.04

ERROR: Could not connect to database specified in connectionString for SqlDataProvider

<connectionStrings>
    <add name="SiteSqlServer" connectionString="Server=(local);Database=dnn;uid=dnn;pwd=dnn;" providerName="System.Data.SqlClient" />
  </connectionStrings>

  <appSettings>
    <add key="SiteSqlServer" value="Server=(local);Database=dnn;uid=dnn;pwd=dnn;" />
    <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" />
    <add key="RemoveAngleBrackets" value="false" />
    <add key="PersistentCookieTimeout" value="0" />
    <add key="InstallationDate" value="9/6/2008" />
  </appSettings>

Yes, I did all of that. I probably should have mentioned I am using SQL express on Windows XP. Anyway...I found a connection string which works for SQL Express (using SQL authentication). This seems to work fine when choosing the 3rd option of the install wizard (auto legacy install). The other 2 install choices just hang endlessly. So it would apear the install script is a bit buggy.

<connectionStrings>
<add name="SiteSqlServer" 
connectionString="Data Source=amd64\sqlexpress;Initial Catalog=dnn;
User ID=dnn;Password=dnn" 
providerName="System.Data.SqlClient" />
</connectionStrings>

<appSettings>
<add key="SiteSqlServer" value="Data Source=amd64\sqlexpress;
Initial Catalog=dnn;User ID=dnn;Password=dnn" />