Could anyone please tell me if below connection string code is correct if i'm using "SQL Server 2008 R2" and Windows7 Pro?
I'm getting an error message The Auto option has been disabled as the DotNetNuke Application cannot connect to a valid SQL Server database during the installation. However, if i click next with either Custom or Typical set up,  it won't go any further from the Run Database Installation Script page.

Run Database Installation Scripts

The installation of the database scripts should have started when this page loaded. The Next button will be disabled until the Installation of the Scripts is complete.

Installing Database - Version 05.00.00...Installing Database - Version 05.00.00...

and I get stuck with this page.

Any comment would be greatly appreciated! Thank you


--Below is my Connection Scripts--

<connectionStrings>
    <!-- Connection String for SQL Server 2005/2008 Express -->
    <add name="SiteSqlServer" connectionString="Data Source=.\MSSQLSERVER2;Initial Catalog=dnnwebsite;Integrated Security=True" providerName="System.Data.SqlClient" />
    <!-- Connection String for SQL Server 2005/2008
    <add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" />
    -->
  </connectionStrings>
  <appSettings>
    <!-- Connection String for SQL Server 2005/2008 Express - kept for backwards compatability - legacy modules   -->
    <add key="SiteSqlServer" value="Data Source=.\MSSQLSERVER2;Initial Catalog=qnexisnuke;Integrated Security=True" />
    <!-- Connection String for SQL Server 2005/2008 - kept for backwards compatability - legacy modules
    <add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>
    -->
    <add key="InstallTemplate" value="DotNetNuke.install.config" />
    <add key="AutoUpgrade" value="true" />
    <add key="UseInstallWizard" value="true" />
    <add key="InstallMemberRole" value="true" />
    <add key="ShowMissingKeys" 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="12/14/2010" />
  </appSettings>

Thank you for your comment. I'm using SQL Server 2008 R2 (not express). I heard that database.mdf is used only with SQL Express.

Does the above mean "default application pooL"? And if so, how do I go about doing that, on a shared-server host? I have the EXACT same issue, installing with the MS Web Application Gallery, and it appears to be just stuck on that "installing database scripts" page. I have no idea what to do, can anyone help? Bear in mind, this is Mochahost we're talking about (slow servers, no real support, running WebSitePanel, which means I don't get a lot of control over settings). Thx, Andria